Path
Stéphane,
Workbooks.Open Filename:= Application.Path & "\" & "Doc"
should do it
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Stéphane Simard" wrote in message
...
I
Could you tell me how can i write this line to tell to Excel to open the
document "Doc" in volume where Excel actualy run?
In this exemple "MYHARDDRIVE"
Workbooks.Open Filename:="MYHARDDRIVE:Doc"
Thank you!
|