By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 1,904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

running excel macro from a web page

P: n/a
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
Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sun, 1 Aug 2004 17:19:02 -0700, "BenJamin" <Be******@discussions.microsoft.com> wrote:

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...b;EN-US;257757

You may want to check some of the alternatives posted in the above article.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.