>One more question, How do I close excel afterwards?
I don't usually do it < G >, since I use Excel mainly as a reporting alternative - the user keeps Excel open, to see the result.
If you have an object oExcel, probably something like oExcel.Quit(), or oExcel.Close().
Saving a macro, as outlined in my article, is complicated here, precisely because you close Excel. The help must be consulted in this case.
If you can't find it, I will investigate.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)