Hi,
I have a spreadsheet which has a macro in it that updates the spreadsheet.
The update macro takes about 3 or 4 minutes to update and save the spreadsheet so I wanted to do the time consuming updates in the background (current thinking was on the server via scheduled tasks).
As you can't run a macro directly from the command line (unless this has changed), one thought was to create a dummy Excel sheet with some code in the Workbook_Open() function to open the desired spreadsheet, run the procedure/macro, save the workbook and then close... all seamlessly in the background.
If I am not able to run from the command line, how can I run a macro from a different spreadsheet?
Cheers,
Woody.
I have a spreadsheet which has a macro in it that updates the spreadsheet.
The update macro takes about 3 or 4 minutes to update and save the spreadsheet so I wanted to do the time consuming updates in the background (current thinking was on the server via scheduled tasks).
As you can't run a macro directly from the command line (unless this has changed), one thought was to create a dummy Excel sheet with some code in the Workbook_Open() function to open the desired spreadsheet, run the procedure/macro, save the workbook and then close... all seamlessly in the background.
If I am not able to run from the command line, how can I run a macro from a different spreadsheet?
Cheers,
Woody.