Excel Automation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me why I get an "Application-defined or Object-defined
error" when I runt this code?

where objXL = "Microsoft Excel"

intEndPointer = objXL.WorksheetFunction.Match _
("JOB STATUS", Worksheets(1).Range("A1:A500",0))
 
How are you instantiating objXL?

You need something like either

Set objXL = New Excel.Application

or

Set objXL = CreateObject("Excel.Application")

or

Set objXL = GetObject(, "Excel.Application")
 
Back
Top