This will be save "Doc" in the folder of the application, no?

Me i want save it on the root of the drive.

in fact, i want know the name of actual drive.

Thank you

De*: "Bob Phillips"
Groupes*: microsoft.public.excel.programming
Date*: Tue, 10 Feb 2004 22:34:02 -0000
Objet*: 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!