Replace EXCEL9.OLB

[JF Miche]

Hello everyone !

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

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 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.

[Eagle]

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

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.

[JF Miche]

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 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.

[DiGro]

Oh boy, no softening on this one, sorry

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 OOo 3.3 NL (Dutch)

[JF Miche]

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.

[JF Miche]

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.

[David]

[JF Miche]

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.