By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,584 Members | 3,447 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,584 IT Pros & Developers. It's quick & easy.

TransferSpreadsheet Method

P: n/a
Hey Guys,

Does anyone know of a way to format the output of the
TransferSpreadsheet method in Access 97 so that the exported
spreadsheet has some formatting (column widths, row heights, cell
colors, bold, italic, etc.)

Thanks in advance, Dean...

May 5 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You'd need to use Automation to do those formatting things in the EXCEL
file. TransferSpreadsheet does not have that capability.

--

Ken Snell
<MS ACCESS MVP>

"DeanL" <de*************@yahoo.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...
Hey Guys,

Does anyone know of a way to format the output of the
TransferSpreadsheet method in Access 97 so that the exported
spreadsheet has some formatting (column widths, row heights, cell
colors, bold, italic, etc.)

Thanks in advance, Dean...

May 6 '06 #2

P: n/a
Best to send the data to a named sheet then use = in another sheet with the
formatting to get the formatting.
scooper
"DeanL" <de*************@yahoo.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...
Hey Guys,

Does anyone know of a way to format the output of the
TransferSpreadsheet method in Access 97 so that the exported
spreadsheet has some formatting (column widths, row heights, cell
colors, bold, italic, etc.)

Thanks in advance, Dean...

May 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.