View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed from AZ Ed from AZ is offline
external usenet poster
 
Posts: 120
Default "Workbooks.Open" fails with 2007??

I am automating Excel through Word VBA. The code is breaking at the
line to open the Excel workbook. THe code has worked great through
Word/Excel 2003 - but the 2007 update was pushed over the weekend and
now it breaks on Workbooks.Open. No other Excel instances are open
when this code runs, and the workbook can be opened with a double-
click with no errors.

Set objExcel = New Excel.Application
objExcel.Visible = True
Set objWkbk = objExcel.Workbooks.Open(FileName:=strLookIn &
"\MyList.xls")

The error is "Method 'Open' of object 'Workbooks' Failed."

Does anyone have any insight on this?

Ed