Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 694
Default VBA with OpenOffice

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default VBA with OpenOffice

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" wrote in message
...
Hi Everyone
Has anyone tried using VBA with OpenOffice software.
Is it 100% compatible ?
Any comments?
Regards
John



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 694
Default VBA with OpenOffice

Hi JLGWhiz
Yes it's available, but how well does it work???
Regards
John
"JLGWhiz" wrote in message
...
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" wrote in message
...
Hi Everyone
Has anyone tried using VBA with OpenOffice software.
Is it 100% compatible ?
Any comments?
Regards
John




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default VBA with OpenOffice

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" wrote in message
...
Hi JLGWhiz
Yes it's available, but how well does it work???
Regards
John
"JLGWhiz" wrote in message
...
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" wrote in message
...
Hi Everyone
Has anyone tried using VBA with OpenOffice software.
Is it 100% compatible ?
Any comments?
Regards
John






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 694
Default VBA with OpenOffice

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" wrote in message
...
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" wrote in message
...
Hi JLGWhiz
Yes it's available, but how well does it work???
Regards
John
"JLGWhiz" wrote in message
...
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" wrote in message
...
Hi Everyone
Has anyone tried using VBA with OpenOffice software.
Is it 100% compatible ?
Any comments?
Regards
John









  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default VBA with OpenOffice

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.


"John" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Hi JLGWhiz
Yes it's available, but how well does it work???
Regards
John
"JLGWhiz" wrote in message
...
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" wrote in message
...
Hi Everyone
Has anyone tried using VBA with OpenOffice software.
Is it 100% compatible ?
Any comments?
Regards
John









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read/Write to OpenOffice David Excel Programming 1 December 8th 09 04:21 PM
OpenOffice macros Greg Lovern Excel Programming 1 May 29th 09 08:48 PM
openoffice xlsm query Sarang Bapat Excel Programming 0 August 8th 07 11:29 AM
OpenOffice Download Needlewich Excel Worksheet Functions 2 May 20th 06 09:20 PM
Openoffice -damaged tmp file IcU812 Excel Discussion (Misc queries) 1 December 2nd 05 08:46 AM


All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"