Competent Performer
Windows 10 
Office 365
Hi all,
I have a report that I export to Excel using the ExportWithFormatting macro. It works okay, but it doesn't keep all the actual formatting from the report (color coded conditional formatting, bold headers, etc.). How can I export this to Excel and keep all that stuff? Or can I export it and run a macro to do it?
VIP
Windows 10 Access 2010 32bit
If it does not export with that setting then it doesn't. Have to format within Excel. And yes, can run VBA code to set formatting.
Why export a report to Excel?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 10 Office 365
Via Excel is how the users want to send the information to certain people. I think I will try to export to PDF instead.Originally Posted by June7
VIP
Windows 10 Office 365
You could simply export the data (not the report) to Excel then format the excel sheet from access?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Exporting to Excel with formatting gives an error every other time
Exporting Access Report to Excel - formatting issues.
Posting Permissions
Reply With Quote