I need to open an excel workbook and run two separate macros from a dos .bat file.
Is this possible?
I need to open an excel workbook and run two separate macros from a dos .bat file.
Is this possible?
I am running Excel version 12.
I don't think a .bat file can do this. Have a look at VBScript (.vbs file) instead.
You can use the .bat to open the file, however, you might want to use Workbook_Open of the file to trigger the routines...
Note you would need to account for Macro Security settings.... and you might also consider using a Scheduler of some sort.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks