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