I got the second routine in this thread to work. The first one I had problems with the Kill command. It may have been something I was doing wrong. Anyway I have one more desire to complete this routine. Is it possible to get excel to close when it is all finished. I tried Quit.Application in a couple of different places but without success. Any suggestions?

PS I guess I can live with everyone at work thinking I am a genious, I will just have to be carefull not to let it go to my head.

Thanks

Scott