I am trying to create an excel report from Access. I have been able t
output the query result to an excel file. But I need to use a templat
for formatting. Can some one tell me how to create a template an
associate it to the new excel file from Access.

Also I need to use a macro to do some formatting. Where do I store th
macro and how do I get the macro to run automatically when the exce
file opens.

Thanks in advance for any help.

Sheri

--
Message posted from http://www.ExcelForum.com