I have the below code, however i was wondering if i can have include the pathway of the folder location in a Cell.
IE: In a new sheet named 'Pathway' in A1 I would have C:\Desktop\ and the macro picks up A1 information. (since location will be changing each day)
Sheets("Upload 1").Move
ActiveWorkbook.SaveAs "C:\Desktop\" & Sheets(1).Name & ".xlsx", 51
ActiveWorkbook.Close
Sheets("Upload 2").Move
ActiveWorkbook.SaveAs "C:\Desktop\" & Sheets(1).Name & ".xlsx", 51
ActiveWorkbook.Close
Sheets("Upload 3").Move
ActiveWorkbook.SaveAs "C:\Desktop\" & Sheets(1).Name & ".xlsx", 51
ActiveWorkbook.Close
Bookmarks