>We have a cursor with some memo fields. We need to send this cursor to an excel spreadsheet and include the memofields.
>
>I have managed to create a spreadsheet with all the data but the fields representing the memo columns can be exceedingly wide. I haven't been able to figure out how to
>
>1. Set the width of the memo fields to be (say) 100
>2. Format the cells so that they do proper wordwrapping
>3. Set the height of the row to fully display the largest memo for that row (row heights will not be the same for all rows)
>
>(actually, I don't even know how to do this from within excel, much less with automation)
>
>I hope this is all clear. Could somebody help with the coding for the final formatting portion?
>
>Thanks to all............Rich
Rich,
I'll e-mail you the program I created using Cetin Basoz VFP2Excel as a starting point.
If it's not broken, fix it until it is.
My Blog