Convert TDMS to EXCEL Error

[No_RegreTs]

Hello,

I've been trying to use TDMS to XLSX.vi to convert my TDMS file to Excel file. (http://forums.ni.com/t5/LabVIEW/Convert-Import-TDMS-to-Excel/td-p/1088746)

On my computer it works fine but when I try it on mu laptop and workstation I got property node error, code ise 97.(Property Node (arg 1) in Convert TMDS to XLSX80.vi)

I use Office 2007. Diadem 11.0 and Labview 2009 SP1

[Brad_Turpin]

Hi No_RegreTs,

Why don't you just load the TDMS file into Excel and save it from Excel as an *.xlsx file?  You can even remote control Excel to do that with ActiveX, here's the VBScript approach to load a TDM or TDMS file into Excel:

Dim Excel, TdmAddIn
TdmsFilePath = AutoActPath & "Example.TDM"
On Error Resume Next
Set Excel = CreateObject("Excel.Application")
IF Err.Number <> 0 THEN Call AutoQuit("Could not contact Excel on this computer")
Set TdmAddIn = Excel.ComAddIns.Item("ExcelTDM.TdmAddin")
IF Err.Number <> 0 THEN Call AutoQuit("Could not access the TDM Excel Addin" & vbCRLF & vbCRLF & "(TDM Excel Addin version 3.1 or later is required)")
Excel.Visible = TRUE
Call TdmAddIn.Object.ImportFile(TdmsFilePath, True)
IF Err.Number <> 0 THEN Call AutoQuit("Could not load the desired data file" & vbCRLF & vbCRLF & """" & TdmsFilePath & """")
Call Excel.ActiveWindow.Activate
On Error Goto 0

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[No_RegreTs]

I dont know using VBscript in LAbview.. Could you please explain it a little bit more. And I need to do this conversion programmatically, its about work. And if I do this with manuel so why do we use labview? 🙂 I just want a subvi ow something else which convert my TDMS file to Excel file.

[Brad_Turpin]

Hi No_RegreTs,

On second thought, that block diagram screenshot you posted is actually using the same Excel TDM Addin library I was suggesting.  I hear you saying you need this to happen programmatically, but we're in debugging mode now.  What happens if you load the TDMS file you were testing with into Excel with your mouse?  Does it work?  How large is that TDMS file?  How many channels and channel values are in it?

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[No_RegreTs]

Here is an example of tdms file in attachments and I converted it to excel file using Convert TDMS to XLSX.vi with my computer. But I couldnt convert it with my laptop and workstation. I got error when I try to use this subvi on my laptop and ws.

[usac]

The Excel Add-In shipping with DIAdem 11.0 does not support the needed COM interface. Please download and install the newest version of the TDM Excel Add-In:

http://zone.ni.com/devzone/cda/epd/p/id/2944

[No_RegreTs]

I did it. It didn't work 😕 And I'm sorry, I wrote it Diadem 11.0 but I've been using the version 11.1

[usac]

Did you try Brads suggestion and load your TDMS file using Excel and the TDM Excel Add-In directly?

Just open Excel, go to the ribbon "Add-Ins" and use "Import a TDM(S) file". Does any error occur? If yes, can you please post the error message or provide a screenshot?

[No_RegreTs]

I clicked the TMDS importer but nothing happened.. 

[usac]

Thanks a lot. Maybe the following article can help you:

http://zone.ni.com/devzone/cda/tut/p/id/5885

It looks like you have the "Non-Responsive Icons" issue.