Excel TutorialExcel VBA TutorialTutorial

Excel VBA: Organise Files into Subfolders based on File Type

This video demonstrates using VBA's FileSystemObject to organise files into subfolders by file type. Please also find the featured VBA code, below. https://www.youtube.com/watch?v=wtpUEvMIvD8  

 

Read More
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

 

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...

 

Read More