Export Access Report to Excel keep format

[deeds]

I have a report in Access, it contains data, and logos, etc. It look great
in Access and I would like that exact look to be exported to excel. Does
anyone know of a way to exactly replicate the report that is generated in
Access and get that in Excel format? Thanks!

 

[Jeff Boyce]

If it is the formatting (i.e., how it looks) that you need to get out of
Access, have you looked into writing it out as a PDF file instead? I
believe the purpose of "Export to Excel" is to give you a way to get the
data out to Excel...


Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[deeds]

Thanks Jeff. Yes, I already have an option for the user to view as a pdf.
They would also like to export to Excel and have it look exactly like it does
in the Access report with Logos, format etc. Any possibilities?

 

[Jeff Boyce]

Perhaps one of the other newsgroup readers has an approach that works for
them. The only way I've ever made Access data fit a specific Excel format
is to automate Excel and push Access data into specific cells with specific
formatting... and that still isn't what you asked to do, i.e., create a
report format in Access, then force Excel to display the same format.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Roger Carlson]

Like Jeff, the only way I can think to do it is to push the data out to a
pre-formatted Excel template.

I have a sample that demonstrates this here:
http://www.rogersaccesslibrary.com/forum/topic350.html


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L