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

How to run XL Macros in Calc?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
onyxgaze
Newbie
Newbie


Joined: 27 Jul 2005
Posts: 2

PostPosted: Wed Jul 27, 2005 3:25 am    Post subject: How to run XL Macros in Calc? Reply with quote

I have an XL workbook with quite a few macros and worksheets.
When I try to open this workbook in Calc it first correctly tells me there are Macros - when I allow macros to run, nothing happens.
When I try to locate the macros, they dont exist.

How do I get the XL macros to run in Calc?

Any help is appreciated.

Thanks in advance.
Back to top
View user's profile Send private message
9point9
Moderator
Moderator


Joined: 31 Aug 2004
Posts: 3875
Location: UK

PostPosted: Wed Jul 27, 2005 7:56 am    Post subject: Reply with quote

Excel macros will not run in Calc as they are written in VBA which is an MS programming language and as such is not supoorted by OOo. If you can access the source code then you could analyse it and re-write it in StarBasic. Unfortunately there is no straight conversion process as the languages used are so different.
_________________
Arch Linux
OOo 3.2.0

OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/
Back to top
View user's profile Send private message Visit poster's website
onyxgaze
Newbie
Newbie


Joined: 27 Jul 2005
Posts: 2

PostPosted: Sat Jul 30, 2005 10:02 am    Post subject: Thanks - I was afraid of that.... Reply with quote

Is there someone who can help with converting the XL macros to Calc Macros written in STarbasic?

Thanks in advance
Back to top
View user's profile Send private message
9point9
Moderator
Moderator


Joined: 31 Aug 2004
Posts: 3875
Location: UK

PostPosted: Sat Jul 30, 2005 10:57 am    Post subject: Re: Thanks - I was afraid of that.... Reply with quote

onyxgaze wrote:
Is there someone who can help with converting the XL macros to Calc Macros


Well, any good OOo macro programmer could and the best path to that would be to learn programming in OOo.
_________________
Arch Linux
OOo 3.2.0

OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc 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