Hi,
I’ve tried importing the Microsoft.Office.Interop.Excel namespace, then within an Invoke code activity putting the following:
Dim xl As Microsoft.Office.Interop.Excel.Application
However, I get the following error message:
Main has thrown an exception
Source: Invoke code
Message: Error compiling code
error BC30002: Type ‘Microsoft.Office.Interop.Excel.Application’ is not defined. At line 1
Exception Type: ArgumentException
System.ArgumentException: Error compiling code
error BC30002: Type ‘Microsoft.Office.Interop.Excel.Application’ is not defined. At line 1
But Intellisense in Invoke Method window gives Microsoft.Office.Interop.Excel.Application namespace.
Did something solve this problem?
Thank you.