Autosize Excel Comments with XML

[WendyWW]

I have a spreadsheet that gets created from inputs on a webpage and within it comments are created. Everything looks great with the exception that the comment boxes are not automatic sized to show all comments. They are shown in preformated size that does not show long comments unless the comments are edited within excel.

Can the Automatic Size be programmed within the generated XML code? If so, how can this be done?

Thanks,

Wendy

[jkmyoung]

The steps would probably be something like:
Try and find the longest comment. Search for the comment element with the longest text length. Multiply this length by some factor, and set the cell width to that.

You could always try word wrap as well.