Read Cell Comments from Excel
Hi all and a Happy Year of 2012, I've seen the info at http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/2a9deeee-c3fa-447a-8d2f-0c954e06cd49 but it doesn't answer my question. Is it possible to get the comments on the cells from excel? How is that done? Best Regards, Pinela.
January 4th, 2012 2:08pm

Happy New Year Pinela, To get the comments you need to incorporate the following code into your Script Task: Dim Comment as String Comment = ExcelApp.ActiveCell.Comment.Text(EmptyParam, EmptyParam, EmptyParam) This link contains many examples for working with comments in Excel: http://www.contextures.com/xlcomments03.html#CopyAdjacent Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2012 2:27pm

Hey Arthur, Thanks for you reply. I have to give a test, even though that requirement has fallen on the project :) BR, Pinela.
January 6th, 2012 9:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics