export TDM to XLS multiple sheets

[MicheleS]

Hi,
I need to export my data from a TDM file to an XLS file.
I would like to export:
- the column 54-55 of the tdm in the first sheet of the XLS file (these are text comment of the rasult file)
- the column 50-53 to the second XLS sheet (these are the index of the test results)
- the column 1-49 to the third sheet (these are the data of the result)

This could be done with a VBS script ?
Note the on the PC I haven't excel so I can't use ActiveX.

Thanks a Lot

[Brad_Turpin]

Hi Michele,

I don't think so.  It would be possible with VBScript and ActiveX, but the DIAdem Excel Export Wizard functions only export to one particular sheet.

Would it help to export the first 2 channels to one Excel file and the other 2 channels to a second Excel file?  That would be possible with a VBScript and the DIAdem Excel Export Wizard functions.

Brad Turpin
DIAdem Product Support Engineer
National Instruments

[MicheleS]

Hi Brad,
Finally I think to Export all the channels in one excel file and use a Macro in Excel to move the channels in different sheet.

Thank you for the answer!