Fetching Comments from a closed work book
Hi,
I want to fetch comments from a closed work book. How can this be done? Thanks, |
Fetching Comments from a closed work book
You could use VBA to silently open the workbook, then use
Workbooks("mybook.xls").Sheets(1).Range("A1").Comm ent.Text to retrieve the comment text from a particular cell. HTH, JP On Mar 13, 10:20*am, wrote: Hi, I want to fetch comments from a closed work book. How can this be done? Thanks, |
All times are GMT +1. The time now is 07:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com