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