Format Cells with VBA?

  • Thread starter Thread starter Gustaf
  • Start date Start date
G

Gustaf

In my Excel app, I load and save data to/from Access, using VBA/ADO code. Loading dates from Access is problematic. I get 39448 rather than 2008-01-01. I can change it manually with Format Cells and pick the short date format, but how would you do that in VBA? Do I have to set the data type for each cell? Setting it beforehand for the whole column doesn't seem to work.

Gustaf
 
After you have completed the import into Excel, run:

Sub Macro1()
Columns("A:A").NumberFormat = "yyyy-mm-dd"
End Sub
 
Back
Top