Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I publish Excel as a webpage so macros work?
We are trying to publish some of the activities we have written on a school
website so the students can use them but when we publish with interactivity on anything to do with the macros will not work (including the buttons the macros are assigned to disappearing). We are desperate to give students access to these resources so we need a way round the problem if anyone can help |
#2
|
|||
|
|||
When you publish an Excel sheet as a web page with interactivity it is no
longer an Excel sheet, or affiliated with Excel. This new web page uses the Office Spreadsheet Component to (SSC) provide Excel-like functionality. It has, however, only a subset of Excel's capabilities and among the many things excluded is the ability to run Excel macros. They totally fall out. That doesn't mean you cannot add automation to the SSC but you have to do by adding script to the web page itself using the SSC's object model which is a differerent animal than Excel. There is more on this at the MSDN site: http://msdn.microsoft.com/office/understanding/owc/ -- Jim "Louise" wrote in message ... | We are trying to publish some of the activities we have written on a school | website so the students can use them but when we publish with interactivity | on anything to do with the macros will not work (including the buttons the | macros are assigned to disappearing). We are desperate to give students | access to these resources so we need a way round the problem if anyone can | help |
#3
|
|||
|
|||
Do you have the ability to get a hold of FrontPage? You may be able to use
the Control Toolbox functions interchangeably between Excel and FrontPage to have the Macros continue to work or by using an Access page saved as a webpage. "Louise" wrote: We are trying to publish some of the activities we have written on a school website so the students can use them but when we publish with interactivity on anything to do with the macros will not work (including the buttons the macros are assigned to disappearing). We are desperate to give students access to these resources so we need a way round the problem if anyone can help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel msoffice97 files will not work in excel msoffice2000 | Excel Worksheet Functions | |||
C++ dll in Excel 97 does not work in Excel 2003 | Excel Discussion (Misc queries) | |||
How can I make Excel Macros created on PC work on Macintosh? | Excel Worksheet Functions | |||
Macros in Excel | Excel Worksheet Functions | |||
Excel 97 macros to Excel 2003 | Excel Worksheet Functions |