Go to the Michigan F65 portal: http://f65.mitreasury.msu.edu/Reports/DataSummaryReport.aspx
Batches of F65s must be downloaded by Municipal Type and Chart of Accounts type. For example, for Townships three files must be download by filtering for Fiscal Year, Local Unit Type (Township), Category, and Sub-Category (All). Save the files with the names;
F652017TownshipsRevenues.xls
F652017TownshipsExpenses.xls
F652017TownshipsSOP.xls
NOTE: the VBA code assumes the column headers begin in row 4. Some of the spreadsheets have been midified to have the column headers in Row 1. Insert 3 rows in this case.