10 steps to create automated Excel reports with VBA 1 - Open your VBA code editor: ... 2 - Understand the structure of a VBA project: ... 3 - Play with the code: ... 4 - Play with the macro recorder: ... 5 - Add some variables and constants: ... 6 - Add some conditions: ... 7 - Create a template and make your life easier: More items... May 21, 2020