[AccessD] Solution in search of a problem

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