Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 8th, 2008, 06:48 AM
Registered User
 
Join Date: Feb 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default How do i run Macro on Web

I would be very grateful if anybody can help me with this.

There is a macro runnig behind a button which actually does some calculation - data comes from different worksheet. It is working fine from Excel then I saved that excel spreadsheet as a web page html format. Everything else is fine when i run my web based spreadsheet but i cant see my macro button in there. Is that possible to run macro on web based spreadsheet?

Thanks,

Vir.


 
Old April 8th, 2008, 02:05 PM
Authorized User
 
Join Date: Mar 2008
Posts: 35
Thanks: 0
Thanked 1 Time in 1 Post
Default

You should have to write VBScript code embedded in the HTML code of the web page.
When you saved the xls file to html, the html code was created for you but not the macros assigned to any buttons (that would need VBScript code).
A good place to get you started with web programming is www.w3schools.com

 
Old April 17th, 2008, 01:04 AM
Registered User
 
Join Date: Dec 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to narendrapawar
Default

As tstav said, you will not be able to get that functionality unless you code that using any web scripting language. The fact here is that as soon as you convert a excel file with macros embedded, into a html file you will loose out the macro functionality. All that you can do is to again code in the html file using vbscript or javascript.

Narendra





Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to run macro from another workbook? rmilward Excel VBA 2 September 26th, 2009 08:00 PM
Run code in Macro Corey Access VBA 4 February 5th, 2007 10:54 AM
run a macro at a certain date s_gh Excel VBA 4 May 17th, 2006 06:34 AM
run macro from asp aspuser27 Excel VBA 3 January 28th, 2005 04:30 AM
Macro Doesn't Run? CoryKutchera Excel VBA 3 January 5th, 2005 10:30 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.