TDM-Excel-Add-In controlled by vba

[Zid]

Hello

We've got an application that generates many TDMS-Files. Now I have to import these files to Excel.
I use the TDM-AddIn and this works fine when I do the import manually.

But I'd like to automate the import using VBA.
I tried the trick with "SendKey" (see http://forums.ni.com/ni/board/message?board.id=60&message.id=5441&query.id=12678#M5441)
but this works (on my systems) only with Excel 2003. Unfortunatelly it has to work with Excel 2007 as well.

Has anyone an idea in this direction?

Many thanks
Raffael

[AlexxxR]

Hi Raffael,

your question is very interesting. I used my contacts and asked at R&D for DIAdem in Aachen for any informations on this. They told me that there is a new version of the Excel-Add-In planned for release in nearly 2 weeks. This means you should wait a little bit and then you can use a new API with several features like VBA-Programming and also something like controlling the Excel-Add-In from DIAdem-Script.

I gave the link you posted in this forum, to the developers and they will reply there as soon the release is finished.

Best regards

Alexander Rudolph

NI Switzerland

[Zid]

Hi Alexander

Many thanks for your help! It's a pleasure that you used your contacts to help me.

So I'm looking forward to this new release.

Best regards
Raffael