Method of Object failed making Excel Visible (XL97)
Posted on 2002-03-14
Sorry for the stupid question - I am new to VB.
I have a simple VB program that launches Excel and creates a new workbook. It works on a lot of machines, but on one machine (400 miles away in our New Jersey office....), it returns an error.
Dim oExcelApp As Excel.Application
On Error GoTo err_handler
1: Set oExcelApp = CreateObject("Excel.Application")
2: oExcelApp.Visible = True
3: oExcelApp.UserControl = True
MsgBox "Error " & Err.Number & " - " & Err.Description & " at line # " & Erl, vbCritical
Our New Jersey rep sees Excel open, then he gets:
Error 2147417851 - Method '~' of Object '~' Failed at line #2".
Any help would be greatly appreciated.