heather from houston
New Member
- Joined
- Sep 25, 2002
- Messages
- 1
Hi,
I am running a data warehouse project and we have a funky system of record we need to read from. The "programmer" who created it has, instead of an RDBMS (or even Access), created a complex directory structure which contains thousands of .mst files.
To compile the mst files for us, he opens Excel, clicks a macro button, and then saves the file as a .csv for us to an ftp server.
My question is ... is there a way to "click" that macro button with some kind of batch file (Windows Script host, Java script, ??)? Then we can have the macro save as .csv and place it in the correct location. The goal is to remove the human intervention in the process.
Please help!!
This message was edited by heather from houston on 2002-09-26 08:31
I am running a data warehouse project and we have a funky system of record we need to read from. The "programmer" who created it has, instead of an RDBMS (or even Access), created a complex directory structure which contains thousands of .mst files.
To compile the mst files for us, he opens Excel, clicks a macro button, and then saves the file as a .csv for us to an ftp server.
My question is ... is there a way to "click" that macro button with some kind of batch file (Windows Script host, Java script, ??)? Then we can have the macro save as .csv and place it in the correct location. The goal is to remove the human intervention in the process.
Please help!!
This message was edited by heather from houston on 2002-09-26 08:31