VBA with OpenOffice

[John]

Hi Everyone
Has anyone tried using VBA with OpenOffice software.
Is it 100% compatible ?
Any comments?
Regards
John

 

[JLGWhiz]

A better question is, is VBA available in Open Office. If Open Office is
not a MicroSoft product, I don't believe it would support VBA. You might be
able to load VB6 and use it.

 

[John]

Hi JLGWhiz
Yes it's available, but how well does it work???
Regards
John

 

[JLGWhiz]

If you have the .dll files that support it, it should work as well as it
does in the Office environment. I don't have Open Office, so I cannot be
absolutely sure what supporting library references it has. But for any
programming language to work, it has to have supporting files that the
compiler can use to translate into executable code.

 

[John]

Hi
From what I can find at Google.many different comments but nothing clear.
This is what 's written at OpenOffice.org
"VBA interoperability project is a joint Novell & Sun incubator project whose
aim is to deliver a way to run Excel and Word macros natively in imported
documents."
(Interoperability) nice word, English is a second language for me but I can use
a dictionary...
I know what the dictionary says but what is it really saying ???
I'm hoping to find someone using it with VBA codes. Also I know it's got its own
Basic language.
Regards
John

 

[JLGWhiz]

Interoperability implies that VBA would function as designed in any files
imported from the MS environment. Personally, I think there should be a
requirement for standardization between application producers that provides
a common programming language for users who are not professional
programmers. For me, VBA was a lot easier to learn than Dos, Macro 4, Lotus
or Quatro. Hopefully, somebody, someday will develop a user friendly
language that does not have to be modified for each new release of an
operating system.