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 Autpen 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
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 Autpen 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