I can't seem to get a code to use for running a .bat file in a macro. I have seen several different codes, but they will not run the command. This bat file is ran, before running a macro in excel. I would like to include this .bat file update in the macro I am using in excel, basically eliminating a step.
The .bat file is located in a network drive, so I don't know if that matters of not. Here is the location of the .bat file:
I:\Call Center Reports\Daily ACD Report\export1\DailyACDReport.bat
I have tried using shell commands, but can't seem to find one that works.
This .bat file pulls reports from a server, as excel files. The macro in excel is just opening each of these updating information for reporting purposes.
Please help, thanks!
Call center geek
The .bat file is located in a network drive, so I don't know if that matters of not. Here is the location of the .bat file:
I:\Call Center Reports\Daily ACD Report\export1\DailyACDReport.bat
I have tried using shell commands, but can't seem to find one that works.
This .bat file pulls reports from a server, as excel files. The macro in excel is just opening each of these updating information for reporting purposes.
Please help, thanks!
Call center geek