Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2003 output file
I would like to know how to write out excel 2003 excel worksheets to separate
files. Basically I need to write out each excel 2003 file generated by a vb.net 2005 desktop application to separate workbooks. Each separate worksheet is going to be email and encrypted for each customer. Thus I would appreciate any suggestions that you have how to accomplish this task. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2003 output file
douglas -
Excel super-guru Ron de Bruin has many varieties of VBA examples for sending workbooks or worksheets via email. See http://www.rondebruin.nl/sendmail.htm - Mike http://www.MikeMiddleton.com "douglas" wrote in message ... I would like to know how to write out excel 2003 excel worksheets to separate files. Basically I need to write out each excel 2003 file generated by a vb.net 2005 desktop application to separate workbooks. Each separate worksheet is going to be email and encrypted for each customer. Thus I would appreciate any suggestions that you have how to accomplish this task. Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2003 output file
"Mike Middleton":
Thank you for your reply. My problem is not how to email files. I want to write one excel worksheet to each excel workbook. I do not want lots of tabs in one excel workbook. I just want one tab filled in for each workbook generated. Thus do you know how I could accomplish this task in VB.net 2005? Thanks! "Mike Middleton" wrote: douglas - Excel super-guru Ron de Bruin has many varieties of VBA examples for sending workbooks or worksheets via email. See http://www.rondebruin.nl/sendmail.htm - Mike http://www.MikeMiddleton.com "douglas" wrote in message ... I would like to know how to write out excel 2003 excel worksheets to separate files. Basically I need to write out each excel 2003 file generated by a vb.net 2005 desktop application to separate workbooks. Each separate worksheet is going to be email and encrypted for each customer. Thus I would appreciate any suggestions that you have how to accomplish this task. Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2003 output file
"AltaEgo":
Thank you for your response! However this link does not answer my question directly. What I want to do is copy data from selected rows in a sql server 2005 database and put those selected rows into separate excel worksheets. I plan to do this in a visual basic.net 2005 desktop application. The only way that I can see to do this to open and close the excel spreadhseet object that is being used in the visual basic .net 2005 application each time I am ready to load data onto the separate spreadsheets. I was hoping to find a way that I could reuse the excel object embedded in the visual basic.net 2005 desktop application. I was also hoping maybe there is some way for me to accomplish this task using 'office automation'. Thanks! "AltaEgo" wrote: http://www.rondebruin.nl/copy6.htm -- Steve "douglas" wrote in message ... "Mike Middleton": Thank you for your reply. My problem is not how to email files. I want to write one excel worksheet to each excel workbook. I do not want lots of tabs in one excel workbook. I just want one tab filled in for each workbook generated. Thus do you know how I could accomplish this task in VB.net 2005? Thanks! "Mike Middleton" wrote: douglas - Excel super-guru Ron de Bruin has many varieties of VBA examples for sending workbooks or worksheets via email. See http://www.rondebruin.nl/sendmail.htm - Mike http://www.MikeMiddleton.com "douglas" wrote in message ... I would like to know how to write out excel 2003 excel worksheets to separate files. Basically I need to write out each excel 2003 file generated by a vb.net 2005 desktop application to separate workbooks. Each separate worksheet is going to be email and encrypted for each customer. Thus I would appreciate any suggestions that you have how to accomplish this task. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application coded in excel 2000 when used in excel 2003 excel doesnot perform well and takes double the time to give the output | Excel Programming | |||
Excel 2003 won't let me select my own regression output range. | Excel Discussion (Misc queries) | |||
Error when saving Excel output file | Excel Programming | |||
output data from excel into text file using vba | Excel Programming | |||
convert an excel prn output file from dos to unix? | Excel Programming |