From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
06-18-2013 04:01 PM
I have a program that will create a TDMS file with the data, and after execution is complete, I would like to import the data into Excel and manipulate it using a macro. I can import the file manually and run the macro by opening a second file containing the macro, but opening up the second file is a hassle.
I would like to expand the macro so that it automatically imports the TDMS file, and based on what I've seen on the forums, in order to do this, I need to register the TDM importer as a COM Add-In. When I go to the COM menu in Excel and try to add ExcelTDM.dll, it does not appear in the menu.
Some additional details that may be helpful:
Excel TDM Importer is version 3.4.0.0
I have already tried uninstalling and reinstalling the importer
Using the Excel toolbar works to import the data
Double-clicking on a file works to import the data
The installed files are located at C:\Program Files\National Instruments\Shared\TDM Excel Importer. Moving them to C:\Program Files\National Instruments\Excel TDM had no effect.
Thank you in advance for your help.
Solved! Go to Solution.
06-18-2013 04:33 PM
06-19-2013 07:54 AM
I've already looked through all of the official literature that NI provides as well as perused the discussion boards for anything on this topic. If I'm overlooking something, please let me know, but the steps in the link you provided and the further links on the page are ones that I have already attempted with no success.
06-19-2013 09:02 AM
Update: I attempted uninstalling the add-in once again. In addition to using Add or Remove Programs, I deleted the downloaded files and the folders the add-in was stored in. I downloaded and installed the latest version (3.4). Still no success getting it to load on the COM Add-ins menu
06-19-2013 09:57 AM
Does the simple VBA example as described here:
http://www.ni.com/white-paper/10207/en
work in your case?
06-19-2013 10:32 AM
@StefanR wrote:
Does the simple VBA example as described here:
http://www.ni.com/white-paper/10207/en
work in your case?
No, it doesn't. Excel does not see the add-in in the COM Add-In window, so I cannot access it using VBA.
06-19-2013 09:59 PM
I didn't see the TDM Importer in the COM Add-ins, but the VBA ran fine...
I tested it on a clean machine with Excel 2003 and TDM Importer 3.4.
06-20-2013 07:08 AM
Can you please provide OS and bitness?
06-20-2013 08:01 AM - edited 06-20-2013 08:01 AM
Mavis, I'm not sure how I failed to try that. Thank you for pointing that out.