The message means that the desired workbook doesn't exist in the same folder

--
Don Guillett
SalesAid Software

"johnh" wrote in message
...
I have two workbooks. The first workbook has macros that get values from
named cells in the second workbook. Everything works fine on one computer.
When I move the directory structure to a second computer and run the
macros,
I get an error when I attempt to get the values of the named cells in the
second workbook. Here's the error.
Run-Time error '9'
Subscript out of range
Any help would be appreciated.