Transfer Spreadsheet loop: Interior color changing

Hello all!

I have an access database that houses information based on any number of projects. I have a form with a multi-select list box with multiple projects that a user can select. The loop starts by selecting the first project selected and running a query based on that project. The query is then inserted into an existing workbook using the transferspreadsheet method in access. After the query is transferred, various code is run to format the data in excel, part of which is setting the selection.interior.color property. After all formatting is complete, the excel workbook is closed, and the loop continues with the next project.

All is fine except the cell colors. If I run just one project, then i get the exact colors i want, however if i run more than one, only the last report exported has the correct colors. All of the previous ones that were exported are different than what they were set as before the workbook was saved.

I'm probably being about as clear as mud, i will try to explain better if needed, but any ideas?

Thanks!
Ryan