Thread: Path
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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!