Hi, I want to fetch comments from a closed work book. How can this be done? Thanks,
G gauravsinha.15 Mar 13, 2008 #1 Hi, I want to fetch comments from a closed work book. How can this be done? Thanks,
J JP Mar 13, 2008 #2 You could use VBA to silently open the workbook, then use Workbooks("mybook.xls").Sheets(1).Range("A1").Comment.Text to retrieve the comment text from a particular cell. HTH, JP
You could use VBA to silently open the workbook, then use Workbooks("mybook.xls").Sheets(1).Range("A1").Comment.Text to retrieve the comment text from a particular cell. HTH, JP
