I have a a batch file that runs a couple macros. I pasted the syntax of what I have in the file below. This works to start Excel and run the macros, but my question is, is there a way I can pass parameters to the macros I am running? I want to be able to set them in the file that runs for the macros, and not have to have any users manually input the values.
START "C:\Program Files\Microsoft Office\OFFICE11\excel.exe" "c:\Macros\My Macro 1.xls"
START "C:\Program Files\Microsoft Office\OFFICE11\excel.exe" "c:\Macros\My Macro 2.xls"
Bookmarks