Run-Time Error '1004': Method 'Open' of Object 'Workbooks' F

RevPar

New Member
Joined
Jan 4, 2007
Messages
7
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.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Checked the file to and it is sitting in the correct location. What I don't understand is that this report worked perfectly before. Nothing has changed but the pc. Any other clues?

I've read somewhere that certain add in's are missing based upon how microsoft office was loaded. Ie Upgraded to 2003 from version 2002 or 2000 versus a new pc with Office 2003 as the first software loaded. Does that make any sense to anyone?

Thanks again for the help.
 
Upvote 0
Is the file really in the C:\Strategy folder?

Do you have access to that folder?

Can you open the folder in the Windows Explorer?

Can you open the file from inside XL with File | Open...?
Checked the file to and it is sitting in the correct location. What I don't understand is that this report worked perfectly before. Nothing has changed but the pc. Any other clues?

I've read somewhere that certain add in's are missing based upon how microsoft office was loaded. Ie Upgraded to 2003 from version 2002 or 2000 versus a new pc with Office 2003 as the first software loaded. Does that make any sense to anyone?

Thanks again for the help.
 
Upvote 0
Yes to all four questions. This is the only machine it doesn't run on. Haven't had trouble on any other pc. I'm lost. Any other clues?
 
Upvote 0
I am having this exact problem except mine was running fine on this machine until about mid day yesterday. After that it just randomly stopped working on my machine. I've tried moving the file to different directories and opening it from there but I still get the same error. I can open the csv file from explorer and excel without a problem I just can't seem to open it through a macro. any ideas?
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,916
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top