Retrieve a Workbook's Parent Folder

[oseitutuSamuel]

Hello Everyone,

I wish to use VBA to retrieve the folder (or path) in which a workbook is located. For example if the workbook is called "MyWorkbook.xlsx" and is located in
"C:\ExcelWorkbooks\" (which means the path to the workbook is "C:\ExcelWorkbooks\MyWorkbook.xlsx"), I want the code to return "C:\ExcelWorkbooks\"

I was hoping to see something like Activeworkbook.ParentFolder property, but there is nothing like that. If this is not achievable with VBA, is there any other way?

Thanks in advance
Samuel

 

[wideboydixon]

ActiveWorkbook.Path

WBD