MSAccess - Excel Automation - Inserting Comments
Posted on 2007-10-15
I am using Excel Automation to dump the results of a query to an XLS spreadsheet, with appropriate formatting.
Is it possible to use Excel Automation to also Insert>Comment to a subset of cells on the resulting XLS sheet. This would provide some textual support for the value in the XLS cell.
I have an XLS sheet with 100 rows, 25 columns. I want to insert a comment (field from the database) to just the Cells with a value of "X".
1. Should I do this when I dump the query recordset to the XLS sheet, or
2. Post process the XLS testing for existance of "X", then DLookup the comment to insert?