B
Bob Barnes
This code..from Access..
objXLSheet.Columns("I:I").NumberFormat = "Short Date"
...or..
objXLSheet.Columns("I:I").NumberFormat = "mm/dd/yy"
...opens in Excel as the date's number, IE 39462
Ideas please? TIA - Bob
objXLSheet.Columns("I:I").NumberFormat = "Short Date"
...or..
objXLSheet.Columns("I:I").NumberFormat = "mm/dd/yy"
...opens in Excel as the date's number, IE 39462
Ideas please? TIA - Bob