Open Office versus Microsoft Excel

[ladimirabdala]

I have a VBA macro who shows the contents of my part list:

Sub Export()
Dim oDrawDoc As DrawingDocument
Set oDrawDoc = ThisApplication.ActiveDocument
Dim oSheet As Sheet
Set oSheet = oDrawDoc.ActiveSheet
Dim oPartsList As PartsList
Set oPartsList = oSheet.PartsLists.Item(1)
Call oPartsList.Export("C:\Exported.xls", kMicrosoftExcel)
End Sub

But I don't have the Microsoft Excel, it's possible make this with the Open Office? Like that:
Call oPartsList.Export("C:\Exported.xls", kOpenOfficeCalc)
The line over returns an error.

Any comments will be apreciated.
Thanks.

Ladimir Abdala
Brazil

[Anonymous]

Can you not just create the Excel .xls file from your macro and import the file into OpenOffice?

[ladimirabdala]

How I can make this? Can you show me a Example?
Because I not have so much experience in VB, I was a LISP Programmer.

[Anonymous]

As far as I am aware you don't need Excel on your machine, IV just creates the file in Excel format. You've already got the code to export the parts list in Excel.

Then you can use anything that can open or import an Excel file to see what you've got.

And the file format doesn't need need to be Excel, there are other options (refer to the IV API help file).

[ladimirabdala]

Dear Peter,
It is truth, has several other types of archive formats, also format .txt. Thanks a lot.