We've upgraded from Office 2000 to Office 2003 and now my excel macro
calls are messed up. There's about a 15 second delay from the time I
make the call in VB.NET to the time the excel macro is actually
executed.
Here's my code:
Dim oExcel As Microsoft.Office.Interop.Excel.Application
oExcel = New Microsoft.Office.Interop.Excel.Application
oExcel.Workbooks.Open(FileName:="c:\test\test.xls" )
oExcel.Run("test.xls!test.test")
I have a reference set to Microsoft Excel 11.0 Object Library.