I had a nice little excel module that ran with out a hitch in Excel 2000, I recently obtained a new Pc and with Excel 2002 on it and the module no longer works. It is stuck on the open method.

ChDir "Drive & folder"
Workbooks.Open "Drive & Folder & Filename"

Says method Open of object workbooks failed.

I can not figure this out.

Swoozie