Learn Excel Reporting Automation For Beginners with Excel VBA (Code Included)

Excel VBA makes a amazing tool to automate reporting. If you work in Accounting or Finance, then being able to create a macro to automate a reporting that usually takes half hour to merely just a minute, and you can re-use the the program over and over again, is going to be a huge time and energy saver.

Excel VBA is the programming language to automate Excel spreadsheet, and the beauty with VBA is that, it is actually pretty easy to pick it up. Excel application on the other hand, is the most widely used spreadsheet in the world today.

In this tutorial I am going to teach you how to start learning automating a reporting process using Excel VBA. You don't have to be an expert in Excel programming, but it is ideal that you have at least have a little bit experience writing macro (Excel VBA).

► Download VBA source code

► Download exercise file

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#ExcepReporting #ExcelAutomation

[karladuenas]

Thanks for sharing. I don't have a background in computer science but I am so thankful for you posting this video as I am interested in learning. Thank you

[bryanbertrand]

Thank you for the video. How do I get the code for the "Learn Excel Reporting Automation For Beginners with Excel VBA (Code Included)". Thanks in advance

[ricardoromo]

when exporting the files, is there a way to rename the Sheet1 to also be the file name?

[hansakaerandaranasinghe]

Dear Jie Jenn Pls advise how this method works on PDF File type.

[moesadr]

I have a dynamic database table with many columns and rows and would like to be able to create a printable report whenever needed. The report needs to be showing only a few columns and those records who have certain criteria ( filtered). Like the stage is "Open" and Rank is " A", and the project value is over $1000, ....etc. Wondering if you might have a template to share. Please advise.

[omgLEWISnKreh]

I can't download the file to follow along. Wish this can be fixed. Otherwise, splendid video!

[Argo-rs]

why am i getting error on Const it is said Not allowed on public members of object modules

[hh]

Hi I tried to replicate by using your vba codes, but one issue is the output files are generated in one folder level up.

I created a folder Excel\Output but instead the output files generated in Excel

I used Excel\Output in line 7:
Public Const Output_Folder_Path As String = Excel\Output"

[hotelrus]

You are very good at coding, but very bad at teaching.