hey all,
I have a macro that at the end saves the current worksheet, the problem is that in another sheet the user uses two cells to name the input and output directory, I would like the save as to be the one named in the other sheet.
example of my current code;
Dim wb As Workbook
Worksheets("File list").Copy
Set wb = ActiveWorkbook
wb.SaveAs "Key Off Time.xls"
wb.Close
The user inputs the output folder path in the worksheet called "Input" cell B2. I need this save code to reference that cell and save as to that directory.
Thanks.
Bookmarks