VBA code to save files to a folder based on a cell value

[Hiren Parekh]

All,
Is there a way to save all excel workbooks created by a macro to be saved by pointing at a cell value.

For example "G:\Financials Reports\2022\03-mar" appears on cell A2 of the main workbook where a macro loops and parses out files based on a listing.

I have this currently but have to change the first part of the code manually each month.

ActiveWorkbook.SaveAs "G:\Financials Reports\2022\03-mar\Variance_Analysis\" & Sheets("Summary").Range("B4")

Thanks.

Hiren

 

[Hiren Parekh]

Nevermind. I figured it out.