OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

VBA and Basic code in a Calc spreadsheet ?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
jcproperty
Newbie
Newbie


Joined: 30 Sep 2011
Posts: 3
Location: Bordeaux

PostPosted: Thu Oct 06, 2011 1:12 am    Post subject: VBA and Basic code in a Calc spreadsheet ? Reply with quote

Hi everyone,

I have a Calc spreadsheet with a set of macros in VBA, attached to the document worksheets with the VBAsupport 1 option.
Since it didn't work properly and since I couldn't translate all the macros in BASIC (lacking time and knowledge), I tuned the code and added new macros in pure BASIC, called from the VBA code. But the BASIC macros don't seem to be willing to work in the Standard module of the document, I had to put them in the Standard module of "My macros and dialog boxes" for them to work.
Does anyone would know the reason to why I can't put BASIC macros in the standard module, while I have VBA macros attached to the sheets ?
Thanks.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group