VBA Code incorrectly formatting data
Hi all
I have the code below in Access which exports data into an existing Excel
spreadsheet. The cells are formatted as general number but the code changes
them to date format. Is there a way to specify the data type before the copy
or should I try and find some code to format the cells after the export code
has run?
Thanks in advance for any help.
Sue
|