active workbook path

[vba-lover]

Dear Experts

How to findout parent folder of active workbook?

[Paul]

This will only work on a workbook that is already saved:

Please Login or Register  to view this content.

To shorten the formula, you could put

=CELL("filename") in any cell, let's say A1. Then, for the formula above replace all instances of CELL("filename") with A1.

Note: Do not change "filename" to your file's name. It literally needs to say "filename" including the quotes.

This formula will give you the full path up to the last "\" before the workbook's name, e.g. "C:\Documents and Settings\pjoaquin\my documents\examples\"

[Steel Monkey]

Alternatively in vba :

Please Login or Register  to view this content.

Again, the workbook needs to have been saved for this to work