469,270 Members | 1,731 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

TransferSpreadsheet And Excel Formatting Problem

I have a TransferSpreadsheet process in my Access 97 database that sends
data out to an Excel spreadsheet formatted with a Times New Roman 10 point
font, centered text, etc...

This always works fine until data gets exported into a cell on the
spreadsheet that never had data in it before. The data uses the default font
(usually MS Sans Serif), is not centered, and will not wrap. When I
originally formatted the spreadsheet I selected the entire sheet for
wrapping and formatted each entire column as centered with the font that I
wanted. Is there a way around this without having to write an Excel macro
and call it from within Access with Excel automation? Why does Excel not
remember formatting for empty cells?
Any help would be much appreciated.

Nov 13 '05 #1
0 1386

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by DeanL | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.