tdm importer macro

[bkling]

Hello, I am recording data into a TDMS file and I am using the TDM Importer add-in for excel to open the tdms files in excel.  I am trying to make a program that will do this automatically, ie: the user clicks a button in my vi to open the file in excel.  I think i could do this using a macro, however I need help making the macro.  Is it even possible to make a macro that uses the tdm importer add-in?  I tried recording a macro but I don't think it recognizes any functions from the add-in.  Has anyone done anything like this?

Thanks

Bryan

[Ching_F.]

Hi Bryan,

This seems like a really interesting task you are trying to accomplish.  I have not tried to do this personally, so I do not know if it is possible.  It may be a difficult as there is not much documentation on this utility.  There are several dlls used the TDM importer located C:\Program Files\National Instruments\ExcelTDM. 

[bkling]

Thanks for the reply Ching,
I think it would be pretty straight forward to make a subvi that reads all of the attributes from at tdm file and writes them to an excel spreadsheet, much like the tdm importer, however this would be a lot of tedious work.  I will look at those dlls and see if I can figure something out.  However, I think that NI should really have a convert tdms to excel spreadsheet tool in the palette, if I may make the suggestion. 
Thanks,
Bryan

[Ching_F.]

Hi Bryan,

One quick question, why are you writing to a TDMS file instead of a spreadsheet?  Are you doing this for speed? 

In any case, I have attached a simple program that I wrote that should convert the TDMS data into a format that can be read by Excel.  Please take a look at this, and let me know if you have any questions.

Best of luck on your application, and have a wonderful day!!!