Auto CSV to Excel to Word

krissz

Board Regular
Joined
Feb 21, 2010
Messages
95
I am trying to use Excel as an interface between CSV files & Word using the 2003 version, the function of Excel being to properly format the data before import into Word.
If anybody can suggest a simpler way, I would be happy to try.
The process is as follows:
- CSV files are updated every night
- I then need to do the following automatically from say a Batch file
*- Open Excel
*- Refresh all worksheets
*- Automatically close Excel (but NOT if opened manually)
I am fairly confident that I can write most of the necessary VBA code needed in Auto_Open or Open Event, but:
?? How can I deal with an unknown number of worksheets ?
?? how can I automaticall save & close is auto-opened, but not when manually ?
Also
Since I have some control of the CSV date, can I embed any format (or other) data within the CSV ?
Many Thanks
Kris
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,095,362
Messages
5,444,022
Members
405,260
Latest member
Khauff

This Week's Hot Topics

Top