I
Igor G.
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!
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!