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 |
Automation to Excel from Access
"Short Date" not a valid NumberFormat in Excel. However, It is valid when used with the Format function. The "mm/dd/yy" NumberFormat is legitimate, but maybe it is being overridden by the code that places the data in the column. You might try altering when the numberformat is added to the column. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Bob Barnes" wrote in message 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 |
All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com