excel worksheet save format

[Christian8y]

I have a questinon regarding saving an existing excel file via ActiveX. The excel file is containing several sheets and I want to save each sheet as tab seperated file. Opening the file and different sheets is no problem.

[Thomasg]

Hello Christian!

Use the _Workbook method SaveAs and set the FileFormat to -4158
For LV 7.0 and Office 2000.

Hope whis helps

Regards

/Thomas