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

Porting VBA functions to OOo

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


Joined: 10 Dec 2008
Posts: 3
Location: Healdsburg, CA

PostPosted: Wed Dec 10, 2008 11:41 am    Post subject: Porting VBA functions to OOo Reply with quote

Hi,

I'm very new to this. I just tried using some functions written for excel in VB in OO Calc and they worked fine. Then I tried adding a module with functions that create a small toolbar (also written for excel) and they cause Calc to hang with the message "BASIC syntax error symbol expected". It will unhang if I click on that error message OK button about 300 times (not an exageration.)

How do I start fixing this?

Can I keep the function module so it will work in both Excel and Calc?

Should I post the code?
Thanks,

Chris
Back to top
View user's profile Send private message Visit poster's website
hol.sten
Super User
Super User


Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany

PostPosted: Sat Dec 13, 2008 3:12 am    Post subject: Re: Porting VBA functions to OOo Reply with quote

cgarai wrote:
Can I keep the function module so it will work in both Excel and Calc?

This is not possible. VBA works in Excel and OOo Basic in OOo.
Back to top
View user's profile Send private message
cgarai
Newbie
Newbie


Joined: 10 Dec 2008
Posts: 3
Location: Healdsburg, CA

PostPosted: Mon Dec 15, 2008 3:27 pm    Post subject: Reply with quote

Perhaps my terminology is incorrect. I have imported one set of VB functions for Excel into OO Calc, but another set won't even load. They hang Calc as it tries to read the functions in.

Thanks,

chris
Back to top
View user's profile Send private message Visit poster's website
hol.sten
Super User
Super User


Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany

PostPosted: Wed Dec 17, 2008 11:55 am    Post subject: Reply with quote

cgarai wrote:
Perhaps my terminology is incorrect. I have imported one set of VB functions for Excel into OO Calc, but another set won't even load. They hang Calc as it tries to read the functions in.

Regardless of what you have already imported, VBA function from Excel will not work in OOo.
Back to top
View user's profile Send private message
cgarai
Newbie
Newbie


Joined: 10 Dec 2008
Posts: 3
Location: Healdsburg, CA

PostPosted: Tue Dec 23, 2008 11:32 am    Post subject: Reply with quote

Let me clarify: One set of VB functions written in the excel Vb editor DO work in OO Calc. One set soes not.
Back to top
View user's profile Send private message Visit poster's website
shirazbj
Newbie
Newbie


Joined: 23 Dec 2008
Posts: 1

PostPosted: Tue Dec 23, 2008 4:50 pm    Post subject: vba or vb Reply with quote

I think if you vba code does not include any operation of Excel object, that is, it is a vb code, it will work in OO. But it still can't operate any OO object.

The OO basic is like VBA. I was wondering if there is a stand alone version of OO basic that like VB, which could creat stand alone program.
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