Hi Gary,

I did a web search on "personal.xls" and I think I found the info
I was looking for. Thanks for pointing me in the right direction.

"Gary''s Student" wrote:

Don't bother to insert the macro. Just include the macro in you personal.xls
file and it should be available whenever you open Excel
--
Gary's Student
gsnu200703


"CityGuy" wrote:

I am using the 'Output to' feature in Access to generate an Excel sheet.

I have written a macro that I manually have to insert to the VBA editor
and execute to format the newly created Excel sheet.

Is there a way to automate the macro insert/run function in the newly
created Excel sheet?

Thanks for your help on this.