Formatting Excel through VBA
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?