[AccessD] Solution in search of a problem

Rocky Smolin rockysmolin at bchacc.com
Fri Dec 2 10:27:51 CST 2011


I have had occasion to create custom spread sheets from access table data
where TransferSpreadsheet wouldn't work.
 
After all of the rows have been written, I use: 
 
objXLWS.Columns("A:U").Columns.AutoFit 
 
and all of the columns automagically adjust their widths to fit the data so
when the user opens it up it looks real pretty and all the data is displayed
- column set to the width of the longest value in the column - but without a
lot of white space which you'd get if you tried to guess the column width
needed.
 
HTH somebody
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> 
www.e-z-mrp.com <http://www.e-z-mrp.com/> 
Skype: rocky.smolin
 



More information about the AccessD mailing list