debbierich22
Programmer
This seems to be a really simple request, but I just can't figure it out. From my ASP page, I want to automatically launch a spreadsheet I have stored on the server after I have updated some data in that spreadsheet.
I have a macro that runs on the opening of the page. Originally, I had it running when a range in the spreadsheet changed and I was changing the range from my ASP page. It turns out that the macro won't execute if the Excel application is not running. (I am not sure if that is expected or that is a problem.)
So now, I have changed the macro to run on open of the spreadsheet instead of on change of the cell's contents.
After the update, I now need to open the spreadsheet within the Excel application to kick off the macro. How do I do this?
I have a macro that runs on the opening of the page. Originally, I had it running when a range in the spreadsheet changed and I was changing the range from my ASP page. It turns out that the macro won't execute if the Excel application is not running. (I am not sure if that is expected or that is a problem.)
So now, I have changed the macro to run on open of the spreadsheet instead of on change of the cell's contents.
After the update, I now need to open the spreadsheet within the Excel application to kick off the macro. How do I do this?