Automating Excel to run a certain macro at startup
Posted by Ed Cupstid on January 17, 2002 1:01 PM
Is there a way to start Excel 2K from the dos prompt and have it run a predefined macro when it starts. We import several CSV files into Excel, these files are all different, but with unique file names. There are macros defined in Excel for each of the unique file names. I would like to automate the process by having a batch file run excel with a parameter telling it which macro to run as it stepped through the batch file. But I have not been to find any documentation saying this is possible. Any help would be appreciated.