I just upgraded from Office 2000 to Office 2003. My VB.NET Excel macro
calls don't work any longer.
Here is how I make my Excel macro call from VB.NET:
Dim objExcel as Excel.Application
objExcel = New Excel.Application
objExcel.Workbooks.Open(FileName:="c:\test.xls", ReadOnly:=True)
objExcel.Run("test.xls!test.test")
I was using the COM object Microsoft Excel 9.0. I noticed that it has
been replaced by Microsoft Excel 11.0. I tried adding that as a
reference but now the Excel object is undefined.
Help!