Thank you for your response! I did this this and it works perfectly thank
you. However I have one slight problem. I save the additional tabs (2 of
them) in a certain cell format with summing in 3 of the cells. When I run my
queries from Access to the Template it accepts the current data but does not
format the two cells I just formatted. Any ideas?

"paul" wrote:

you need to save your transfer workbook as a template delete all the info out
of it and then save it again.when you open a template you open a copy,not the
template itself
--
paul

remove nospam for email addy!



"TKM" wrote:

I have several Access databases and I was infomed for a quick and direty way
I can make a pre formatted workbook then use the transfer spreadsheet for my
report. I dont want the spreadsheet to lose its formatting everytime a user
runs a report. Is anyoen familiar with this process? I can do the trangfer
from Access and use the recorded macro on Excel's end but is there anything
else I need to do?

Thanks in advance