In this series of videos I demonstrate how to create an automated invoice template in Excel. You can download the invoice template using the form below. This automated invoice template includes VBA macros that will save the invoice either as an Excel workbook or a pdf. The template will also email invoices to your customers… Read More »How to Create an Automated Invoice Template in Excel
This video demonstrates how to count and sum based on the background colour of a cell. The solution uses custom VBA functions. Download the featured file here. Please note I cannot upload macro enable files to this website, so you will need to copy the code shown below. Here are the custom VBA functions featured… Read More »COUNTIF & SUMIF On Colour Using VBA Custom Function
Using the FileSytemObject The FileSystemObject (FSO) provides a useful way to access the filing system on your computer and network drives. To use the FSO you first need to create a reference to the Microsoft Scripting Runtime Library. In the VBE click Tools | References. Check the option Microsoft Scripting Runtime and click OK. You… Read More »Excel VBA File Management Using The FileSytemObject