Write and SaveAs Excel files 
Author Message
 Write and SaveAs Excel files

I have problem as follow,
I have  excel files itch in different folder, named as "source11" ( in one
dir) and  "report11" (in other dir) ( e.g for November) , Every month I copy
and rename them as "source12" and "report12", and in some cell in "report12"
write  number, 12, it need also to change links in "report12"  to refer to
the "source12". I have 4 different excel files and I do this every month.
In one of my previous application, I have problems like, .exe file and excel
file must be in same dir, but I need to start an .exe file from any location
different from excel file location
How can I do this with an VB application,
Thanks in advance

Sun, 04 Jul 2004 22:27:40 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Overwriting Exisiting Excel File w/SaveAs

2. Write a Excel File Without Excel App

3. Write to an Excel file from VB without Excel present

4. Writing Excel Files W/O Existing Excel Application

5. Writing Excel-files w/o Excel present?

6. ANNOUNCE : Platform independent toolkit for writing excel file format files

7. VB script in Excel to SaveAs and not prompt user to replace

8. Excel Using SaveAs Dialog Box in Macro Code

9. Dialog box saveas in Excel,

10. Suppress msgbox under Excel's SaveAs

11. VBscript / Excel SaveAs question

12. Saving Excel workbook w/o SaveAs dialog?


Powered by phpBB® Forum Software