| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error opening another excel file using vba
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error opening another excel file using vba
Rob Moore wrote: 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 here is and idea. What about mapping a drive to the server and then trying that path..?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Resolve Error in opening Excel File zip file from a CD? | Excel Discussion (Misc queries) | |||
| "Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
| error opening excel file | Excel Discussion (Misc queries) | |||
| error opening excel file | Links and Linking in Excel | |||
| Error:Invalid File format,while opening an Excel Template file | Excel Programming | |||
Linear Mode
