|
Subject:
|
How do i run Macro on Web
|
|
Posted By:
|
virall23@yahoo.com
|
Post Date:
|
4/8/2008 6:48:53 AM
|
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.
|
|
Reply By:
|
tstav
|
Reply Date:
|
4/8/2008 2:05:30 PM
|
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
|
|
Reply By:
|
narendrapawar
|
Reply Date:
|
4/17/2008 1:04:47 AM
|
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
|
