I am tinkering with a hobby project in Excel that I would like to open and run a macro in after I log onto Windows.
So I am thinking along the lines of a bat file. The bat file would contain a hard-coded path to the XSLM. The desired outcome is that it would cause the XLM to open and run a macro.
- Is this doable? If yes, what should the bat file contain and where should it be placed to auto-run? (I would be using Windows XP as the OS)
- If a bat isn't technically possible, would there be some other means to achieve this end? IDK, vbscript maybe?
- I assume that it may not be possible to specify a specific macro in the XLM to run? If not, I could call the macro from the workbook_open event.
Bookmarks