This is a cool function that lets you save MySQL query data to an Excel spreadsheet. This is good for taking a backup or if you want to change a lot of information fast, then re-upload it.

I will use the config.php and class.mysql.php files from MySQL DB Class with Extras, so please look at those also.

This macro will add a footer to your Excel worksheets. I use this at work because every Excel spreadsheet I do has to have my department and initials in the footer. This macro checks to make sure you are the author of the workbook, and it will not overwrite an existing footer. Just place this code in your personal macro workbook in the ThisWorkbook object.