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:

Not a solution, but..

What I did when I needed formatted sheets whas to create a template
sheet with all formatting in it. Then I copied the sheet to a new
name in the code and wrote in the data. The formatting in the origanl
file was maitained. I don't don't know if this would work for you.

If I understand your problem you format sheet1 and it works.
You then format sheet2 and it doesn't.
Try closing excel between the sheets and see if that helps.
Just a guess.

Good Luck
Ira Solomon

On 1 Aug 2003 13:04:27 -0700, janthony (AT) harrahs (DOT) com (janthony) wrote: