Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keep conditional formatting when exporting to excel

Status
Not open for further replies.
storl2

storl2

Programmer
Jun 3, 2004
47
US
I have a command button that exports a report to a new Excel file (or overwrites the existing one, if it's there), which works fine, but I have some conditional formatting in the report that the OutputTo command does not keep. The strange part is that if I export using file>export, it keeps the some of the formatting fine. Is there some parameter or other module that I need to throw in there?

What I have now is:

DoCmd.OutputTo acOutputReport, "Report", acFormatXLS, "file path", True
 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
509
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Report Header and Column Formatting Issue 1
Replies
2
Views
649
BallunarCrew
BallunarCrew
lameid
  • Locked
  • Question
Docmd.OutputTo Not Exporting Subreport
Replies
2
Views
309
lameid
lameid
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
220
GPnew
GPnew
breezett93
  • Locked
  • Question
Sending report via email only works when Outlook is closed
Replies
1
Views
405
breezett93
breezett93

Part and Inventory Search

Sponsor

Back
Top