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

VBA interoperability

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


Joined: 18 Jul 2009
Posts: 3

PostPosted: Sat Jul 18, 2009 10:17 am    Post subject: VBA interoperability Reply with quote

I have been provided with a spreadsheet in excel which gives me most of what I want but not all. From comments made by the provider there is VBA coding.

I saw that there was a programme within OOo for VBA interoperability but so far have not found out whether this is complete or not.

Can anyone offer guidance in this matter.
Back to top
View user's profile Send private message
AndrewZ
Moderator
Moderator


Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA

PostPosted: Fri Jul 24, 2009 12:29 pm    Post subject: Reply with quote

First, make sure you are using the latest OpenOffice.org. Then, you may wish to try one of the OpenOffice.org derivatives such as OxygenOffice or Go-Oo.
_________________
<signature>
* Did you solve your problem? Do others a favor: Post the solution
* OpenOffice.org Ninja
* BleachBit
</signature>
Back to top
View user's profile Send private message Visit poster's website
scunnered
Newbie
Newbie


Joined: 18 Jul 2009
Posts: 3

PostPosted: Sun Jul 26, 2009 11:29 pm    Post subject: VBA interoperability Reply with quote

Many thanks Andrew

I went to the latest version 3.1 but still have problems with the end results. Looks very much like code problem.

Will have a look at the alternates and see what develops.

Once again thanks
Back to top
View user's profile Send private message
scunnered
Newbie
Newbie


Joined: 18 Jul 2009
Posts: 3

PostPosted: Mon Jul 27, 2009 7:03 am    Post subject: VBA interoperability Reply with quote

I am now well confused as when I followed up on AndrewZ post and loaded 3.1 anything I tried would not work.

Having posted advising this and returning home I tried messing about with the sheet again only to find that when I tarted it up prior to printing everything started working.

How this effected a solution is beyond me but I am happy to say it now works.

Thanks again for all your kind assistance
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 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