Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Office Compatibility with Microsoft office
The issue at hand is that I have an excel sheet that is posted on the web for
customers to access and use. The excel sheet contains a validate button that runs a Macro to validate the format of the data entered. However one of the customers has the OpenOffice - alleged Excel compatible on his PC and every time he downloads the spread sheet the sheet comes in design mode therefore the Macro doesn't run. I tried to exit the design mode but couldn't. Is there anything I may be able to do in order to put the spreadsheet in design mode again so he can run the macro or is the OpenOffice incompatible and the macro would never run? Please advice ...your help is greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Office Compatibility with Microsoft office
according to this
http://en.wikipedia.org/wiki/OpenOffice.org Open Office does not yet run VBA. -- Regards, Tom Ogilvy "Student" wrote: The issue at hand is that I have an excel sheet that is posted on the web for customers to access and use. The excel sheet contains a validate button that runs a Macro to validate the format of the data entered. However one of the customers has the OpenOffice - alleged Excel compatible on his PC and every time he downloads the spread sheet the sheet comes in design mode therefore the Macro doesn't run. I tried to exit the design mode but couldn't. Is there anything I may be able to do in order to put the spreadsheet in design mode again so he can run the macro or is the OpenOffice incompatible and the macro would never run? Please advice ...your help is greatly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Office Compatibility with Microsoft office
Thank you very much
"Tom Ogilvy" wrote: according to this http://en.wikipedia.org/wiki/OpenOffice.org Open Office does not yet run VBA. -- Regards, Tom Ogilvy "Student" wrote: The issue at hand is that I have an excel sheet that is posted on the web for customers to access and use. The excel sheet contains a validate button that runs a Macro to validate the format of the data entered. However one of the customers has the OpenOffice - alleged Excel compatible on his PC and every time he downloads the spread sheet the sheet comes in design mode therefore the Macro doesn't run. I tried to exit the design mode but couldn't. Is there anything I may be able to do in order to put the spreadsheet in design mode again so he can run the macro or is the OpenOffice incompatible and the macro would never run? Please advice ...your help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convertion of Star Office documents to Microsoft Office | Excel Discussion (Misc queries) | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
Office 2007 compatibility at office 2003 is not working for graphs | Excel Discussion (Misc queries) | |||
how do i open up a spreadsheet in microsoft office | Excel Worksheet Functions | |||
Open Microsoft Office Applications from another computer? | Excel Discussion (Misc queries) |