Issues with Export Access report with Now() to Excel

[bet]

In Access 2010 report, there is a Now() which is a long date with time format and it looks fine in the Access report. However, it gets converted to numeric format when exported to Excel spreadsheet. I have to manually format it to date in Excel. This is a problem since I have so many reports to be exported to Excel from Access 2010. Can that be corrected when export to Excel? Any help is greatly appreciated.

[TheShabz]

Just a thought, create a macro (or module) in Excel that formats a column to a certain type. During your export procedure, Open Excel, export, run macro/module, save, exit. Set the visible attribute to 0 (or false, or whatever it is) and you wont see any of it happen.

[bet]

so I would need to write VBA code in Access module to Open Excel, format the cell and get it ready to accept the report with the Now() format? This sounds pretty complex, and I have so many reports...is there any other way? Doesn't there any type of add on to fix this bug? Thank you for your help.

[TheShabz]

You wouldn't have to write the code out for each report, so the number of reports doesn't really mean much. You could also start with a preformatted xls that you populate.

I don't know of an addon that can do this for you. you can google for some Access APIs but who knows what you'll find in there.