Run-time error '1004'

[muziq2]

Hi all,

Some users are getting the following error.

"Run-time error '1004' Method 'open' of object 'workbooks' failed."

Obviously I'm not sure why. The user has to click on a link that open
the excel sheet. Then they click on a button on the sheet that open
another sheet read only and updates the original sheet. When th
button is clicked the error is showing up. The files are in the sam
directory so if the user is able to open the file via the link the use
should also be able to open the other file.

This is happening in excel 2000 but the file works fine on my box i
excel 2000.

Any ideas?

Thanks,

Jeff
Jef

 

[Jake Marx]

Some users are getting the following error.

"Run-time error '1004' Method 'open' of object 'workbooks' failed."

Please see response to your later post on this subject.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]