I need to go from absolute to relative paths.
My macro is in folder \models\vba
and this macro uses sheets from the folders \models\Main ,and \models\aear as below
Set Main = Workbooks.Open("D:\Shared\Models\Main\Main 2017.xlsx")
I've been shopping around already, and it seems its easiest to use
ThisWorkbook.Path
What's the best way to go back one directory, and then enter the Macro map.?
D:\Shared
directory related to the location of the workbook file?*.xlsx
/*.xls
workbook file, or multiple files? How is your "macro in a folder"?