![]() ![]() The object type variables are needed for the part of the program that creates the email. I then declare all variables with their proper type (i.e., Integer, String, and Object). I start the macro with Option Explicit to make sure I’ve declared all variables. The last three sections occur within the same loop. The macro can be broken into four sections: You follow the steps I took to create the “Invoice Generator” macro. You’ll have the ability to do the same if This process with VBA, saving Pro PowerWashing more than $500 in labor each In just a few hours, I was able to automate Week every month creating and sending invoices! The company was spending nearly a full work ![]() Staggering 2,250 minutes a month…or 37.5 hours! Houses – and 750 invoices – per month! At 3 minutes per invoice, that’s a Three minutesīut since Pro PowerWashing works about 25ĭays a month, and their crew of 10 washes about 30 houses a day, that’s 750 Take too much time… and it doesn’t for just one invoice. They saved it as a PDF, attached the PDF to an email, and manually typed the Master Excel MACROS & VBA in ONLY 1 HOUR!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |