I used the following code to open a file.
2 users at 2 different sites have different path to the same excel file.
i used an error handler to overcome this. but it seems not working
a run time error 1004 appears when it tries to open the file from the first
path and in fact the correct path is the secon one

Workbooks.Open FileName:= _
"I:\_Other_Site\DIESE HARNESS OFFSHORING\00 HARNESS DESIGN
ROUTING\02 Work Request Generator\Harness Routing WR template vE.xls" _
, UpdateLinks:=0
On Error Resume Next
Workbooks.Open FileName:= _
"I:\_My_Site\DIESE HARNESS OFFSHORING\00 HARNESS DESIGN ROUTING\02
Work Request Generator\Harness Routing WR template vE.xls" _
, UpdateLinks:=0
On Error Resume Next

you must set error handler before error not after.

"linto" wrote in message
...
|I used the following code to open a file.
| 2 users at 2 different sites have different path to the same excel file.
| i used an error handler to overcome this. but it seems not working
| a run time error 1004 appears when it tries to open the file from the
first
| path and in fact the correct path is the secon one
|
| Workbooks.Open FileName:= _
| "I:\_Other_Site\DIESE HARNESS OFFSHORING\00 HARNESS DESIGN
| ROUTING\02 Work Request Generator\Harness Routing WR template vE.xls" _
| , UpdateLinks:=0
| On Error Resume Next
| Workbooks.Open FileName:= _
| "I:\_My_Site\DIESE HARNESS OFFSHORING\00 HARNESS DESIGN ROUTING\02
| Work Request Generator\Harness Routing WR template vE.xls" _
| , UpdateLinks:=0
| On Error Resume Next