Thread: Folder name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Herbert Herbert is offline
external usenet poster
 
Posts: 23
Default 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