I've seen several different posts for this error but can't seem to find the answer I am looking for. I have the following Code in VB:
Workbooks.Open filename:=("C:\Strategy\Rates.xls")
This command use to work just fine with no problems what so ever. but now I got a new pc and I get the following error:
Run-Time Error '1004': Method 'Open' of Object 'Workbooks' Failed
and the debug highlights the command above. Any Clues??
I am running on Windows Xp, Office 2003. Excel 2003 with SP2. All the programs and OS are identical to what it was before the new pc. Even the PC's are the same. It's just a new one.
I can run this report on another pc with the same os and office product and it runs beautifully.
Hope someone out there can help.
Thank you.
Workbooks.Open filename:=("C:\Strategy\Rates.xls")
This command use to work just fine with no problems what so ever. but now I got a new pc and I get the following error:
Run-Time Error '1004': Method 'Open' of Object 'Workbooks' Failed
and the debug highlights the command above. Any Clues??
I am running on Windows Xp, Office 2003. Excel 2003 with SP2. All the programs and OS are identical to what it was before the new pc. Even the PC's are the same. It's just a new one.
I can run this report on another pc with the same os and office product and it runs beautifully.
Hope someone out there can help.
Thank you.