Thread
:
Automation to Excel from Access
View Single Post
#
1
Posted to microsoft.public.excel.misc
Bob Barnes
external usenet poster
Posts: 134
Automation to Excel from Access
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
Reply With Quote
Bob Barnes
View Public Profile
Find all posts by Bob Barnes
Automation to Excel from Access