Formating Excel via Access

K

Kevin

I have exported an Excel file from an Access query, and would like for Access
to progmatically change some formatting on the spreadsheet. Specifically, I
would like to change the widths of columns A-F, and bold Row 1. Ideally, I
would like to also set the data to AutoFilter, but I realize that is probably
a bit overzealous!

Thanks in advance,
Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating Excel via Access 3
Integrating information from Word to Excel (not mail merge) 1
Excel does not accept text format! 0
VBA - (re-) Set a Table Style 2
How to Build an SQL Query on the Fly for Data Export to Excel 4
Cobditional Formatting Rows based on dates in action plan. 0
Apply cell formatting using VBA 2
Conditional Format Using If 2

Top