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

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


---
Message posted from http://www.ExcelForum.com/

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

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)

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

ThisWorkbook.Path & Application.PathSeparator

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Flystar " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

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

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

ActiveWorkbook.Path & Application.PathSeparato

--
Message posted from http://www.ExcelForum.com