How to set worksheet cell width for exported Access file to Excel

G

Gary S

I am exporting a file from MS Access to MS Excel, and I would like to
modify the default cell width in the Excell file. I tried creating a
workbook template with modified cell widths and save it to the XLSTART
folder. This works for new workbooks created in Excel, however, for
the exported report files via Access, the cell width is not carrying
through. Is there an Access export option to utilize for this?
Any Excel options and/or suggestions I can use?

Thanks to all who respond.
Gary
 

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

Worksheet default cell width for Access export to Excel 0
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
Access export to Excel and set default cell width 0
Preserving trailing zeros for a fixed width file 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Modify Excel default cell width for Access export file 0
How to create portable Excel applications? 2

Top