| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open Fails
I trying to implement Ron's code for merging multiple workbooks (
http://www.rondebruin.nl/copy3.htm) , but the procedure fails to open the workbooks. Im getting Method 'Open' of object 'Workbooks' failed as an error. The spreadsheets are autogenerated by our technology group and each sheet is named something like .xls)CE_Vs_PE_Report_For_Multip If I open the worksheet and remove ANY character from the sheet name, the procedure will open that workbook. Is there anyway to correct this? Thanks for you help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbooks.Open fails | Excel Programming | |||
| workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
| Workbooks.open method fails | Excel Programming | |||
| Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
| Open method of workbooks fails when Excel is hosted in IE | Excel Programming | |||
Threaded Mode
