How to use "machine name" in new report vi?

[taaxman]

I have a computer on a network that has Microsoft excel installed. On another computer I have an application that will take an excel file and stuff a bunch of data from a database into specific cells to generate a report. The vi works fine on my computer (where excel is loaded locally) but when I try and run the VI and access excel remotely I get an error message as follows:

Error -41106 occurred at NI_Excel.lvclass:new report subVI.vi -> NI_report.lvclass:New Report.vi -> printTestSheet.vi

Possible reason(s):

Report Generation Toolkit: Microsoft Word or Excel did not open. Make sure Microsoft Word or Excel is installed.

Error -41106 occurred at NI_Excel.lvclass:new report subVI.vi -> NI_report.lvclass:New Report.vi -> printTestSheet.vi
Possible reason(s):
Report Generation Toolkit: Microsoft Word or Excel did not open. Make sure Microsoft Word or Excel is installed.

I have included the ip address of the remote machine to the "machine name" input of the "New Report" vi.

Any suggestions/solutions?

Gerry Thompson

[Fred_V]

Hi Gerry,

One reason that you may get this error is if Distributed COM wasn't enabled on the remote machine. See this Microsoft KB for how to check or enable that functionality.

If that doesn't help; let me know, and I'll try to setup a similar test case on my end. The process isn't well documented, and I haven't seen any existing examples, so I'd like to see what it takes to get it running.

All the best,