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

Replace EXCEL9.OLB

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
JF Miche
General User
General User


Joined: 24 Jan 2006
Posts: 5
Location: France

PostPosted: Tue Jan 24, 2006 4:56 am    Post subject: Replace EXCEL9.OLB Reply with quote

Hello everyone !

I am an end user and I have succesfully installed OOo suite yesterday. Smile

I am using a VB application developped by a relative to log measurement data in our lab (from pressure and temperature probes mainly). At the end of the measurement sequence, we can export the data to an Excel file Embarassed in order to plot it.

This is no longuer possible with files created with OpenOffice, whenever I rename the file extension to XLS. My relative told me that the VB routine involves a object linking library nammed EXCEL9.OLB to do the exportation job. I there something equivalent to EXCEL9.OLB ?

Many thanks
_________________
I am also looking for free web gallery editor for non specialist.
I apologize for bad writing, my mother language is French.
Back to top
View user's profile Send private message Visit poster's website
Eagle
General User
General User


Joined: 19 Jan 2006
Posts: 19
Location: Norway

PostPosted: Tue Jan 24, 2006 5:22 am    Post subject: Reply with quote

I am not sure what you want to do, but you can not alter the file format by simply renaming the file extention Confused

If you want to read a Excel file into OOo simply open it with File, Open.

If you have a spreadsheet in OOo Calc and want to use it with Excel, just use File, Save as and select the proper file format.
Back to top
View user's profile Send private message
JF Miche
General User
General User


Joined: 24 Jan 2006
Posts: 5
Location: France

PostPosted: Tue Jan 24, 2006 7:35 am    Post subject: Dear Eagle Reply with quote

Thanks for prompt reply

(oh, Eagle ! I have your photo on my gallery - see Plumes (feather) -)

Changing the extrension is exactly what i did at first, but since the OLB is provided by MS, this is not sufficient. I suppose Rolling Eyes that this library is really dedicated and looks for some specific stuff of MS, eventhow I am just using a raw file separated by tabs or ";" (I do not remember).

Let me explain the whole thing as follow:

step0: Customizing : the operator can select (he ticks the label of) pressures and temperatures of interest to export for further chart display in XLS file as per preset template (or OOo calcul file).

step1: Experiment and historical data logging. the operator starts an experiment and our routine that scan the input signals vs time at all com ports, and converts them (through drivers) respectively into pressure1, pressure2 etc temperature1 etc.. Finally, all that stuff is saved into a text file format (separated by tabs).

step2: Exportation: exportation is done as soon as the experiment is completed. This interest of this automatic exportation are :a) to use template with preset charts b)the operator does not need any knwoledge in computer, he just clicks on START at step 1.

This step 2 cannot work anylonger since I am now using non proprietary MS file, whenever I am changing the file extension of my template before executing the routine.

Such process could accomodate OOo assuming a library similar to EXCEL9.OLB exists

I hope this is more clear and that someone can help me
_________________
I am also looking for free web gallery editor for non specialist.
I apologize for bad writing, my mother language is French.
Back to top
View user's profile Send private message Visit poster's website
DiGro
Super User
Super User


Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

PostPosted: Tue Jan 24, 2006 8:25 am    Post subject: Reply with quote

Oh boy, no softening on this one, sorry Embarassed

As far as I know you can't use VB in OpenOffice in this way.
OK that's not entirely true, but you will have to rewrite every macro in you're Excel to OOo's native StarBasic.

Since I don't know what EXCEL9.OLB is doing can't help you further on this.
_________________
DiGro

Windows 7 Home Premium and AOO 4.0.1 NL (Dutch)
Back to top
View user's profile Send private message
JF Miche
General User
General User


Joined: 24 Jan 2006
Posts: 5
Location: France

PostPosted: Tue Jan 24, 2006 8:46 am    Post subject: No macro is involved Reply with quote

No macro is involved in Excel. Only chart facility is used, and that I can easilly set in OOo.

This EXCEL9.OLB (object module library) is used by my external routine written in VB (not VBA). This is a part of this routine that needs adjustment.

Is there any way to write to read a TXT file and then write it OOo Calciul spreadsheet ? This question may look shildish but I am not a computer-man
_________________
I am also looking for free web gallery editor for non specialist.
I apologize for bad writing, my mother language is French.
Back to top
View user's profile Send private message Visit poster's website
JF Miche
General User
General User


Joined: 24 Jan 2006
Posts: 5
Location: France

PostPosted: Tue Jan 24, 2006 8:50 am    Post subject: wrong spelling Reply with quote

I mean:

Is there any way to read a TXT file and then write it OOo Calcul spreadsheet ? This question may look childish but I am not a computer-man

Thanks
_________________
I am also looking for free web gallery editor for non specialist.
I apologize for bad writing, my mother language is French.
Back to top
View user's profile Send private message Visit poster's website
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Tue Jan 24, 2006 10:17 am    Post subject: Re: wrong spelling Reply with quote

JF Miche wrote:
I mean:

Is there any way to read a TXT file and then write it OOo Calcul spreadsheet ? This question may look childish but I am not a computer-man

Thanks


Change the file extension to .CSV and Load it into calc. Thne use that data for graphing. If tab delimiters are a problem, then change them to commas. There are lots of past references on this if you do a search. If unsure on how to change the extension, it's just a file name edit; easily done in Windows. Or, you can try using the CSVed freeware program I've mentioned a few times.

David.
Back to top
View user's profile Send private message
JF Miche
General User
General User


Joined: 24 Jan 2006
Posts: 5
Location: France

PostPosted: Tue Jan 24, 2006 10:51 am    Post subject: Thank you for reply and for help Reply with quote

David, I understand perfectly your answer that works manually. Anyway, I would like to keep the advantage of our routine which can do importation to XLS type file automatically and after "filtration" (see previous post) in unattended way (everything is set on monday for all week experiences).

For that purpose, and up to now, this involved the said OLB library. I think this could be "just" a DLL to replace, but I am not skilled enough (oh, no !) to be sure.

Did someone know about "what it exactly does" or have already used this library in a "former life" so we could better define a replacement tool?
_________________
I am also looking for free web gallery editor for non specialist.
I apologize for bad writing, my mother language is French.
Back to top
View user's profile Send private message Visit poster's website
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