I have created a macro that opens another excel file (prices.xls) copies
several cells, closes the file and then pastes data into my original file
(estimate.xls). When prices.xls is located on my hard drive it works fine.
However when I try to put it on a server (where it needs to be in production)
I get a 'run-time error 424'. Here is the code that I use for both.

Workbooks.Open Filename:="c:\Prices.xls"
Wookbooks.Open Filename:="\\server\shared\estimating\prices.xls"

Any guidance would be greatly appreciated.
Thanks