Formatting lost when exporting from Access to Excel template
Posted on 2013-11-06
I am using TransferSpreadsheet in Access 2010 to export data from a pass through query to an Excel worksheet which has been preformatted with specific colors, column sizes, etc. This usually works fine but sometimes the formatting is not preserved. Is there anything I can do to guarantee that the formatting will not be changed?
Note: I use vba code which always runs the TransferSpreadsheet the exact same way, exporting to the same target worksheet and the same range name.