Pre formated workbook. Can it be done?

[TKM]

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

 

[paul]

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

 

[TKM]

It did not do it. I deleted all the data and save it as a template like you
said. The I outputed my Access report back to the template (I think) and the
formatting is back to the original mess. What did I do wrong?

 

[TKM]

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?