Excel Add-In: COM Automation only as administrator?

[eddi0102]

Hi,

as I tried to connect to TDM (see code below),  I've got the message that it need admin authorisation

Set obj = Application.COMAddIns.Item("ExcelTDM.TDMAddin")

obj.Connect = True

Is it really necessary to have Admin authorisation?

Thanks

Eddi

[DesasterMaster · Accepted solution]

Hi Eddi,

as you see here, you need to start Excel in Admin mode once after theinstallation of the TDM Excel Add-In:

http://www.ni.com/white-paper/4906/en/

Hope this will help you.

Best wishes

Dennis

[vitaminac]

Hi,

With Excel 2013 in Windows 8 I have to do it everytime I open the file.

I believe it's due to compatibility configurations within applications that are not visible or tweakable for a user...

any thoughts or similiar experience?

thanking in advance,

Miguel

[vitaminac · Accepted solution]

hi,

I ended up by foundin the answer to my problem and came back to share it.

i used the TDM Excel Add-In: COM Automation example of NI.

Get TDM Excel Add-In
 Dim obj As COMAddIn
 Set obj = Application.COMAddIns.Item("ExcelTDM.TDMAddin")
 obj.Connect = True

Just remove/comment the part

obj.Connect = True