Скачать или смотреть Excel VBA Macro: Save File As Previous Day (to Specific Folder)

💼 Hire Me for Excel VBA Automation
Need help automating your Excel workflows? I specialize in building custom Excel VBA solutions to save you time and eliminate repetitive tasks.
👉 https://www.upwork.com/freelancers/~0...

Excel VBA Macro: Save File As Previous Day (to Specific Folder). In this video, we go over how to save the active workbook with the previous date in the file name. We also use other past and future dates in this example.

Code:

Sub save_previous_day()

ActiveWorkbook.SaveAs Filename:="C:\Users\greggowaffles\Documents\Youtube Videos\Test\" & _
"Countries of the World " & Format(Date - 1, "mm-dd-yyyy")

End Sub

Data used in this video:
https://gsociology.icaap.org/datauplo...

#ExcelVBA #ExcelMacro