Excel VBA Save File as Prior Month End Date

This video illustrates how to create code in Excel VBA to save an Excel Workbook with the "Prior Month End Date" as the File Name. This process is made easier through the use of VBA Object Variables that are used to refer to both the original workbook and the copied workbook that we plan to save.

Learn More about Excel VBA & Macros with this Book on Amazon:
https://amzn.to/3xnqT6R

Get a Microsoft Office 365 Personal Subscription with this Amazon link:
https://amzn.to/3aV9GtL

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.

To get a copy of the workbook used in the video click on the link below and look for the Title and FileName that matches this video title.

https://theexcelcave.weebly.com/excel...

#ExcelVBASaveFileAsPriorMonthEndDate
#ExcelVBAGetPreviousMonthEndDate