Set Cell width through D5

[MARTINRODDY]

Does anyone out there know how to stretch the width of cells in spreadsheet so that the exported data all fits.

I am exporting data from a string grid in my program to Excel spreadsheet. But when this happens the cells are not big enough

Appreciated
Martin

 

[TealWren]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/womthAutoFit.asp

I think the function is called AutoFit. That URL explains it a bit.

TealWren

 

[ryanb]

I've been wrestling with this problem also, I found the answer in this faq: faq102-1562.
The part that you are looking for is described in step 8.

My thanks to the original author of the faq. It's saved me lots of time.

 

[svanels]

Rate it.

Regards S. van Els
SAvanEls@cq-link.sr