Can someone tell me how to open a file from within a macro where the file name needs to be a variable? Currently using
Workbooks.Open (ThisWorkbook.path & "\Ridgemark 12-1-17.xls")
but want to use a variable in place of the "Ridgemark 12-1-17" file name.