Month: October 2019

Excel TutorialExcel VBA TutorialTutorial

Excel VBA: Archive Workbooks Based on Date Created

https://youtu.be/ALiKqrW51mc This video features the code you could use to move workbooks to another folder, but only if the workbook was created before a specified date. In our scenario, workbooks created before Jan 2019 are archived, any other workbooks remain in the original folder. Here's the code featured in the video Sub ArchiveFiles()…

Read More
Excel TutorialExcel VBA TutorialTutorial

Excel VBA: Combine Multiple Workbooks into One

https://www.youtube.com/watch?v=sOyxlkzWIqs This video demonstrates how to combine all Excel workbooks in a folder into a new workbook using VBA.  All sheets in each workbook will be copied to a new workbook. The VBA code featured in the video... Sub CombineWorkbooks() Dim Path As String Path = "C:\Users\Blue Pecan\Desktop\Combine Workbooks Example\" Dim FileName As…

Read More