I want to keep my formatting when exporting to Excel using a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I export a query to Excel using a macro I lose formatting such as
percent, number of decimal places, etc. How do I keep this using a macro?
 
Sadly, you can't. You will have to do your formatting in Excel.

The only other way to do this is to use Automation and manipulate the
formatting using VBA.
 
Back
Top