Importing Excel Comments into Access

[dbelsey]

Hi All,

I've inherited an application that makes liberal use of DoCmd.TransferSpreadsheet to transfer Excel data into Access tables. Nothing broken there. Now I need to import Excel cell comments as well. I've found some third-party stuff that claims to do that, but third-party isn't an option since it would take too long to clear it through official channels. I just have to believe there's a way to either import comments directly, similar to TransferSpreadsheet, or, at worst, grab them cell-by-cell from Access. Problem is, if such a way exists, I can't find it.

Does anyone have any suggestions?

 

[combo]

With excel automation it is possible to access given worksheet. It has 'Comments' collection. 'Text' property keeps comment's contents. 'Parent' refers to cell with the comment, and next the 'Address', 'Row' or 'Column' properties could be helpful to locate the comment.

combo

 

[dbelsey]

Thanks, combo. I'd run across that before but hadn't had much luck with the tests I'd built for myself. I'll work at it a bit more. I figured once I could actually read a comment then I'd worry about where it came from.

Dave