macro to go to folder one above current folder

[pdpatel81]

i want macro for going backwards of current folder

like

C:\Users\aa\Google Drive\ftr\gyth\tango.xlsm

now i can get active workbook path by
path=activeworkbook.path that is
C:\Users\aa\Google Drive\ftr\gyth

but i want to go to folder one above my active workbook folder that is

what is macro to get this path ???
C:\Users\aa\Google Drive\ftr

[MarvinP]

Hi pdpatel and welcome to the forum,

Here is a User Defined Function that will give back the path one up from the one the activeworkbook is in.

Please Login or Register  to view this content.

Copy the above code into a VBA Module. Then in a cell you can use the function called UpPath. In a blank cell type "=UpPath()" and press enter.