Folder name
 

In VBA how do I find the name of the folder my current workbook is saved to
?

Regards

John

Folder name
 

Hi,

ActiveWorkbook.Path

That of course only returns a value if your workbook has been saved before.

Herbert



"John Peach" wrote:

In VBA how do I find the name of the folder my current workbook is saved to
?

Regards

John

Folder name
 

ThisWorkbook.Path

If the workbook has not been saved yet, this will error.
Mike F
"John Peach" wrote in message
...
In VBA how do I find the name of the folder my current workbook is saved
to ?

Regards

John

Folder name
 

A workbook that has not been saved would be saved to

application.DefaultFilePath

by default,

"Mike Fogleman" wrote:

ThisWorkbook.Path

If the workbook has not been saved yet, this will error.
Mike F
"John Peach" wrote in message
...
In VBA how do I find the name of the folder my current workbook is saved
to ?

Regards

John