Files and Folders Management with FileSystemObject in VBA

In general when we write VBA scripts we either trying to automate an office application task like in Excel, Outlook, Word, or Access, or we are trying to implement a functionality to an existing program. One thing makes VBA versatile is its ability to work with...

A Better Way to Perform a Vlookup (or just any lookup) in VBA

Knowing how to perform a lookup task is important and critical in Excel. Majority of the spreadsheets out there probably have some sort of lookup formula embedded. Perform a Vlookup task is pretty easy on the Excel UI, you simply use the VLOOKUP (or INDEX/MATCH)...

List Hyperlinks From All The Worksheets with VBA

If you work with an Excel workbook that contains many hyperlinks across many worksheets, and you want to create a report to list out the information of each hyperlink, doing that manually sounds crazy to me (I have seen that in real live that actually...

Merge Multiple CSV Files in Excel with VBA

Merge bunch CSV files into one single Excel file manually requires a lot of time and efforts, and on top of that, it’s a painful task. What if you can automate the process with just a single macro?In this tutorial, I will teach you how to write a VBA script to...