Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to disable "New" "open" menu items in Excel 2007 | Excel Programming | |||
"Lines on 2 Axes" fails on Excel 2007 | Excel Programming | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
VB Editor doesn't "recognize" open workbooks | Excel Programming | |||
Where can I find other arguments & desc to the Workbooks.open("myfile.xls") cmd? | Excel Programming |