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 Pain it would be to manually copy all the following from their data sheets to They didn’t realize, however, how much of a
0 Comments
Leave a Reply. |