Hi there,
I put together a suite of macros to automate the running of reports through Excel. These reports fetch data from an ODBC connection, refresh a Pivot Table, create a copy of the workbook and save it to a designated folder. This works great for the majority of our clients. However...