How to get the full path name of the open workbook in a macro

[Flystar]

How can I get the full path name for the open workbook using a macro? I
have tried using the CurDir() function but it is not working.

eg. If I open my workbook from C:\Data\Excel\, I want to be able to get
this string "C:\Data\Excel\"

I am using excel 2000 on Win98SE

 

[Melanie Breden]

How can I get the full path name for the open workbook using a macro? I

have tried using the CurDir() function but it is not working.

eg. If I open my workbook from C:\Data\Excel\, I want to be able to get
this string "C:\Data\Excel\"

try this:

strPath = ActiveWorkbook.Path & "\"

--
Regards
Melanie Breden
- Microsoft MVP für Excel -

http://excel.codebooks.de (Das Excel-VBA Codebook)

 

[Rob van Gelder]

ThisWorkbook.Path & Application.PathSeparator

 

[Flystar]

Thank you for your replies. I have chosen to go with a combination:

ActiveWorkbook.Path & Application.PathSeparato