Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Workbooks present in the same directory
Hi,
I am creating a macro that will use data that resides in the same directory as the file that has the macro code. My Macro runs like this: Workbooks.Open "Slash Daily Case Closed.xls" When I open the file (reports.xls) from explorer and run the macro it gives me error 1004. However, when i use File Open and open reports.xls, the macro runs perfectly fine. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
listing all sheets in all workbooks in a directory | Excel Programming | |||
open in old directory save in new directory | 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 | |||
summary of multiple workbooks in a directory | Excel Programming | |||
Count of workbooks in a directory | Excel Programming |