Pre formated workbook. Can it be done?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TKM - 20 Oct 2006 23:10 GMT

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

Reply to this Message

paul - 21 Oct 2006 23:03 GMT

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

Signature

paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!

> 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
[quoted text clipped - 4 lines]
>
> Thanks in advance

Reply to this Message

TKM - 23 Oct 2006 16:43 GMT

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?

> 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
[quoted text clipped - 8 lines]
> >
> > Thanks in advance

Reply to this Message

TKM - 15 Nov 2006 15:43 GMT

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?

Reply to this Message