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

C

Carolla

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?
 
K

Klatuu

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.
 
Top