running excel macro from a web page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have been given the task of publishing a business process to the companies web portal. What I have to do is to publish an excel spreadsheet to a web page that has several buttons which run macro's after the required data has been entered onto the spreadsheet.
So far I have tried to publish the spreadsheet to the web which does not publish the buttons or the macro's.
So now I have been trying to call the macro's prgrammaticaly after placing my own buttons on the web page allong with the spreadsheet. This has been successful except for one thing. THe macro's throw up message boxes which just stop the web page from reloading, and don't show themselves.

My question is, "is there anyway to catch this event and handle it in the code that calls the macro, or is there a better way to accomplish this task that I have missed "

Thanks in Advance
BenJamin
 
¤ Hi,
¤
¤ I have been given the task of publishing a business process to the companies web portal. What I have to do is to publish an excel spreadsheet to a web page that has several buttons which run macro's after the required data has been entered onto the spreadsheet.
¤ So far I have tried to publish the spreadsheet to the web which does not publish the buttons or the macro's.
¤ So now I have been trying to call the macro's prgrammaticaly after placing my own buttons on the web page allong with the spreadsheet. This has been successful except for one thing. THe macro's throw up message boxes which just stop the web page from reloading, and don't show themselves.
¤
¤ My question is, "is there anyway to catch this event and handle it in the code that calls the macro, or is there a better way to accomplish this task that I have missed "

Unfortunately no, which is one of the reasons why Microsoft does not recommend or support automation
of Office applications from a web application.

INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757

You may want to check some of the alternatives posted in the above article.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top