I've got a program that creates different spreadsheets in Excel, then after I create them, I run some code that is suppose to go through the spreadsheet and format it, such as setting certain fields to bold text, etc.

The problem I keep having is that it works fine the first time I run it, but then after that the formatting part stops working. Everything else works as normal.

If I shut Access altogether, it works fine the first time I run it again.

Any ideas of what is getting hung up?

John

__________________
John