| View previous topic :: View next topic |
| Author |
Message |
cgarai
Newbie
Joined: 10 Dec 2008
Posts: 3
Location: Healdsburg, CA
|
 Posted: Wed Dec 10, 2008 11:41 am Post subject: Porting VBA functions to OOo |
 |
|
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 |
|
 |
hol.sten
Super User
Joined: 14 Nov 2004
Posts: 3531
Location: Hamburg, Germany
|
| Posted: Sat Dec 13, 2008 3:12 am Post subject: Re: Porting VBA functions to OOo |
|
|
| 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 |
|
|
cgarai
Newbie
Joined: 10 Dec 2008
Posts: 3
Location: Healdsburg, CA
|
| Posted: Mon Dec 15, 2008 3:27 pm Post subject: |
|
|
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 |
|
|
hol.sten
Super User
Joined: 14 Nov 2004
Posts: 3531
Location: Hamburg, Germany
|
| Posted: Wed Dec 17, 2008 11:55 am Post subject: |
|
|
| 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 |
|
|
cgarai
Newbie
Joined: 10 Dec 2008
Posts: 3
Location: Healdsburg, CA
|
| Posted: Tue Dec 23, 2008 11:32 am Post subject: |
|
|
| 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 |
|
|
shirazbj
Newbie
Joined: 23 Dec 2008
Posts: 1
|
| Posted: Tue Dec 23, 2008 4:50 pm Post subject: vba or vb |
|
|
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 |
|
|
|
