View previous topic :: View next topic |
Author |
Message |
valterb The Anomaly (earlier version)
Joined: Sep 23, 2005 Posts: 463 Location: San Giuliano Terme, Pisa, Italy
|
Posted: Mon Nov 03, 2008 6:18 am Post subject: Excel macro |
|
NeoOffice, AFAIK, is the only mac application that can run Excel macro (even MS Office 2008 can't do it).
Now I have a document that I would like to open but where there are few problems in macro BASIC, so I cannot use it.
Is there anyone that could help me understanding where the problem is and let me use this document.
Link to the document is http://www.hse.gov.uk/stress/standards/pdfs/analysistool.xls
Thanks!!!
Valter |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Mon Nov 03, 2008 1:03 pm Post subject: |
|
From the macro errors that I saw when I opened the file, the problem is that the macro author is using some advanced VBA commands that NeoOffice does not support.
NeoOffice supports most of the Excel VBA commands but in your file, they are using commands like "public", "private", "copymem", and "byval" that are not Excel VBA commands, but are advanced VBA programming features. There are no equivalent features in OpenOffice.org's StarBasic language for these advanced VBA features so NeoOffice's VBA parsing code will error.
In short, unless the author rewrites their VBA macro to not use these advanced features, you will need Microsoft Office 2004 to run the macros.
Patrick |
|
Back to top |
|
|
shades Keymaker
Joined: Aug 18, 2005 Posts: 96
|
Posted: Tue Nov 04, 2008 12:06 pm Post subject: |
|
pluby wrote: | From the macro errors that I saw when I opened the file, the problem is that the macro author is using some advanced VBA commands that NeoOffice does not support.
NeoOffice supports most of the Excel VBA commands but in your file, they are using commands like "public", "private", "copymem", and "byval" that are not Excel VBA commands, but are advanced VBA programming features. There are no equivalent features in OpenOffice.org's StarBasic language for these advanced VBA features so NeoOffice's VBA parsing code will error.
In short, unless the author rewrites their VBA macro to not use these advanced features, you will need Microsoft Office 2004 to run the macros.
Patrick |
Howdy. Just to be clear: "public" and "private" refer to the scope in which the specific VBA code is applicable. "Public" means that it is a workbook level piece of code, whereas as "private" is a worksheet level command. Both use VBA commands. Often times, "private" modules are used to house VBA functions that work only on that specific worksheet. The "byVal" is a referent in the definition of the VBA function. Thus, re-writing may not be a possibility if this indeed an analysis tool.
So, while not necessarily "advanced", these are still not supported by Star Basic. |
|
Back to top |
|
|
valterb The Anomaly (earlier version)
Joined: Sep 23, 2005 Posts: 463 Location: San Giuliano Terme, Pisa, Italy
|
Posted: Wed Nov 05, 2008 12:23 am Post subject: |
|
Thanks a lot for your helps and explanations.
Unfortunately I do not have a PC in my office (at the moment 3 Macs and 1 Ubuntu) nor I have intention to spend the amount of money requested to buy a PC + windows licence + MS Office licence (but I will donate some money to NeoOffice for the EAP program this week). And I think that's incredible that MS does't support any Excel Macros in their Mac-Office version. |
|
Back to top |
|
|
rob_06 Captain
Joined: Oct 26, 2006 Posts: 74
|
Posted: Wed Nov 05, 2008 1:39 am Post subject: |
|
I have Office 2004 for Mac and could try and open the file if it does not contain personal data and see if resaving it makes any difference in Neo Office if it would help.
Just lets know and I can try pretty much as soon as I see any word. |
|
Back to top |
|
|
shades Keymaker
Joined: Aug 18, 2005 Posts: 96
|
Posted: Wed Nov 05, 2008 11:39 am Post subject: |
|
But keep in mind that VBA in Office 2004 is based on VB 5, the same as Office 97 on the Windows side. Whereas Office 2002/2003 is based on VB 6, so you still might not be able to run everything. |
|
Back to top |
|
|
rob_06 Captain
Joined: Oct 26, 2006 Posts: 74
|
Posted: Wed Nov 05, 2008 10:00 pm Post subject: |
|
Hmm I can also try under windows and office 2003 if needed via my work laptop which I have if it would help in any way. |
|
Back to top |
|
|
valterb The Anomaly (earlier version)
Joined: Sep 23, 2005 Posts: 463 Location: San Giuliano Terme, Pisa, Italy
|
Posted: Fri Nov 07, 2008 11:01 pm Post subject: |
|
Thanx for the help.
What I'm doing is trying to understand how this file handles data (that are not personal) because authors do not gave information. If I had this information I would try to "translate" it for Neo/OOo. This tool is the only "public" tool I know to perform that task (stress evaluation in the workplace).
Valter |
|
Back to top |
|
|
pdofak Blue Pill
Joined: Nov 29, 2008 Posts: 1 Location: Prudhoe Bay, AK
|
Posted: Sat Nov 29, 2008 10:14 pm Post subject: another sheet |
|
HI!
As long as we are on spreadsheets, here's another one that I am surprised and disappointed that the macro won't run in NeoOffice.
http://mcproductions.arrigaffer.com/tmp/Blank2009.xls
Does it look like it could be corrected for Neo or am I stuck having to visit a dagum Windoze machine? eeeeewwwww...
Thanks heaps for looking,
PD |
|
Back to top |
|
|
narf The Anomaly
Joined: Jan 21, 2007 Posts: 1075
|
Posted: Sun Nov 30, 2008 8:53 am Post subject: Re: another sheet |
|
pdofak wrote: | As long as we are on spreadsheets, here's another one that I am surprised and disappointed that the macro won't run in NeoOffice.
http://mcproductions.arrigaffer.com/tmp/Blank2009.xls
Does it look like it could be corrected for Neo or am I stuck having to visit a dagum Windoze machine? eeeeewwwww... |
I opened up the document and I did not see any macros under the menu Tools :: Macros :: Organize Macros :: NeoOffice Basic.
--fran |
|
Back to top |
|
|
narf The Anomaly
Joined: Jan 21, 2007 Posts: 1075
|
Posted: Sun Nov 30, 2008 9:15 am Post subject: Re: another sheet |
|
narf wrote: | I opened up the document and I did not see any macros under the menu Tools :: Macros :: Organize Macros :: NeoOffice Basic. |
I could not see the macro when I opened the document in NeoOffice but I finally found it by opening your file in Microsoft Excel 2004. Your macro is not a VBA macro but is a set of Excel cells with commands in them.
Unfortunately NeoOffice's underlying OpenOffice.org code that imports Excel files cannot understand this type of macro. Only some (but not all) VBA macros in Excel documents can be imported into NeoOffice.
--fran |
|
Back to top |
|
|
shades Keymaker
Joined: Aug 18, 2005 Posts: 96
|
Posted: Sun Nov 30, 2008 1:10 pm Post subject: |
|
Since I don't have Excel I can't open it. But my guess is that the code is again on the worksheet level (in Excel right-click or CTRL-Click on worksheet name and it should give the option to View Code), rather than the workbook level (which is normally accessed through the VBA Editor). And from what I understand the worksheet level code is not usable in OO/NeoO. |
|
Back to top |
|
|
|