I have a code that I am building that will open a workbook in a different location based on what user is using the code.
The path where the code will be running from will be something like Project Management\Employee Name\Projects\Project Number\subfolder 1\sub folder 2.
And I will need the code to look into this path Project Management\Employee Name\Projects\Excelfile.xslm.
Is there a way I can do this? I know I can use Application.ActiveWorkbook.Path to find the original path, but how can I go back a couple of folder levels??
Thanks in advance.
The path where the code will be running from will be something like Project Management\Employee Name\Projects\Project Number\subfolder 1\sub folder 2.
And I will need the code to look into this path Project Management\Employee Name\Projects\Excelfile.xslm.
Is there a way I can do this? I know I can use Application.ActiveWorkbook.Path to find the original path, but how can I go back a couple of folder levels??
Thanks in advance.