W
WembleyBear
Hi all
I have this code to open 3 workbooks, but of late, the second line fails
with the Error 1004 Open Method of Object failed. I've checked that the file
is called the same (it is), that it's in the right directory (it is), that
someone else doesn't have it open (no-one does) and that there are no typos
(I don't think there are!). If I remove the second line, it works fine. I'm
at a loss what else to look for, any suggestions as to how to find what's
wrong would be great:
Workbooks.Open Filename:="X:\ACCOUNTS-EAST\New MA Project\Management
Accounts\2009\USED SALES.xls"
Workbooks.Open Filename:="X:\ACCOUNTS-EAST\New MA Project\Management
Accounts\2009\CONTRACTS.xls"
Workbooks.Open Filename:="X:\ACCOUNTS-EAST\New MA Project\Management
Accounts\2009\CENTRAL OVERHEADS.xls"
Thanks
Martyn
I have this code to open 3 workbooks, but of late, the second line fails
with the Error 1004 Open Method of Object failed. I've checked that the file
is called the same (it is), that it's in the right directory (it is), that
someone else doesn't have it open (no-one does) and that there are no typos
(I don't think there are!). If I remove the second line, it works fine. I'm
at a loss what else to look for, any suggestions as to how to find what's
wrong would be great:
Workbooks.Open Filename:="X:\ACCOUNTS-EAST\New MA Project\Management
Accounts\2009\USED SALES.xls"
Workbooks.Open Filename:="X:\ACCOUNTS-EAST\New MA Project\Management
Accounts\2009\CONTRACTS.xls"
Workbooks.Open Filename:="X:\ACCOUNTS-EAST\New MA Project\Management
Accounts\2009\CENTRAL OVERHEADS.xls"
Thanks
Martyn