ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formatting Data (https://www.excelbanter.com/excel-programming/326621-formatting-data.html)

Mohamed AlKhatib

Formatting Data
 
Hi,
I have data on MSAccess table and I usually export it to MSExcell, I would
like to know how to autoformat the cells instead of doing that manually each
time.




Gary Brown[_5_]

Formatting Data
 
Record a macro doing the formatting once. Put it in your Personal.xls. Call
it up each time you want to format the MSAccess output.
HTH,
Gary Brown


"Mohamed AlKhatib" wrote:

Hi,
I have data on MSAccess table and I usually export it to MSExcell, I would
like to know how to autoformat the cells instead of doing that manually each
time.






All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com