Format exported Excel cells

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

Guest

I was created export to Excel in this form for about 50 products:

Private Sub Command3_Click()
DoCmd.TransferSpreadsheet 1, 8, "Product1", "D:\Export.xls", True
DoCmd.TransferSpreadsheet 1, 8, "Product2", "D:\Export.xls", True
DoCmd.TransferSpreadsheet 1, 8, "Product3", "D:\Export.xls", True
...
EndSub

How I can in this code insert date formating for B column in every exported
sheet in time format h:mm?
Thanks!
 
You can't do any formatting with TransferSpreadsheet.
If you need to do any formatting from Access to an Excel sheet, you will
need to use Automation.
 
Back
Top