Convert Macro's to Javascripts?

[R1chard]

My spreadsheet contains a whole load of Macro's.

Is there a piece of software which would convert these macro's into Javascript if i was to upload my spreadsheet as a website? Or does anyone know a way in which i could upload my spreadsheet as a website and for it to still to function correctly?

 

[DonkeyOte]

If you're running the site yourself on say IIS then you can use ASP which is similar in structure to VBA

eg

ASP tag (< followed by %)
If x = ... Then
...
Else
...
End If
close tag (% followed by>)

Without knowing what the macros do or what the spreadsheet is hard to say really.

This site shows some VBA-esque ASP commands if you want to rewrite in ASP

http://www.haneng.com/FunctionSearch.asp?s=a

Just a suggestion

 

[santeria]

There is literally a bundle of things you can do. ASP conversion is a great way, but it does involve recoding.
In some cases, if you presume that whoever views your page has a browser that can read native excel, loading a live XLS file will actually work.

Anyway, a few notes:

Pay for Conversion:

http://www.convertzone.com/xls2htm/help.htm


Html,Java,Perl, and Tips etc

http://www.codetoad.com/


Tutorials on how to convert pages

http://www.plu.edu/~dmc/flipchart_excel_to.html


And etc....

There is literally heaps of ways to present your material on the web.
So it seems.

 

[R1chard]

ok, thank you all for your help!!

 

[tusharm]

Don't know if you are still looking for ideas, but why not upload the XL file as is (or better yet, zip it with WinZip or one of its competitors) and let folks download it onto their own machine and use it there?

Best way to preserve XL-compatibility, don't you think?

ok, thank you all for your help!!