What code do I need to put around t 1

[Jamie2002]

What code do I need to put around this to say if the file is already open then skip this command...

Workbooks.Open Filename:="C:\Documents s\Desktop\Financial_Model.xls"

Thanks.


Thanks

Jamie

 

[RobBroekhuis]

on error resume next
workbooks("Financial_Model.xls&quot.activate
if err<>0 then
err.clear
Workbooks.Open Filename:=&quot;C:\Documents s\Desktop\Financial_Model.xls&quot;
end if

Rob