Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

Download or installation problems? Try these steps
Problems after upgrading to NeoOffice 2022? Try these steps


Support
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


RSS Feeds
· Announcements Only
· All Posts


  
NeoOffice :: View topic - Can't find the macro module for an .xlsb file
Can't find the macro module for an .xlsb file
 
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
timrichardson
Pure-blooded Human


Joined: Oct 07, 2007
Posts: 39

PostPosted: Thu Jun 23, 2011 5:23 pm    Post subject: Can't find the macro module for an .xlsb file Reply with quote

Hi. I have a xlsb file which has a macro sheet developed in Excel 2010.
When I open it in calc, I can't see the macro module. It is not protected or invisible.
Cells referring to custom functions show an error #MACRO?
Calc has macro security setting "low"
In the VBA Properties settings tab, all options are ticked.

I'm using neoffice 3.2 latest patch.
If this is not a known problem I can send the file. Not keen on posting it in the forum for all to see.
Back to top
View user's profile Send private message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11937

PostPosted: Thu Jun 23, 2011 5:58 pm    Post subject: Reply with quote

NeoOffice's underlying OpenOffice.org code has only very limited compatibility for converting Microsoft Excel macros. So, most likely the problem is caused by one of the following:

1. NeoOffice's underlying OpenOffice.org code has not fully implemented reading of .xlsb files. To test if this is the cause, open your .xlsb file in Excel 2010, select the File :: Save As menu, change the Format to .xlsm, and press the Save button. This will save a new .xlsm file. Does the same problem appear when you open the .xlsm file?

2. If the same problem appears when you the .xlsx file saved above, then most likely Microsoft has made changes to the VBA macro language in Excel 2010 and NeoOffice's underlying OpenOffice.org can only understand limited portions of the Excel 97/2000/XP VBA macro language.

In either case, please note that NeoOffice's underlying OpenOffice.org handles Excel VBA macros by attempting to convert them to the OpenOffice.org Basic macro language. Since there are many cases where there is no direct match between Excel VBA and OpenOffice.org Basic, there is no guarantee that your Excel macros will run in NeoOffice or OpenOffice.org.

Patrick
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.02 Seconds