Friday, February 24, 2012

Cell comments in Excel Export

Is it possible to include a cell comment when exporting a report to Excel? My first guess was that the Textbox.ToolTip property might do the trick, but no luck.

Example: I am calculating a textbox based on the age of a particular value in days and conditionally formatting it. In the Excel export, I would like to have a cell comment (i.e., "insert comment" from the context menu in Excel) that shows how many days past the age limit the item is when it is formatted.

Thanks much for any help!

Through conventional export methodologies? No. But ofcourse through VBA/ADO anything is possible.

Adamus

No comments:

Post a Comment