| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fetching Comments from a closed work book
Hi,
I want to fetch comments from a closed work book. How can this be done? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDIRECT should be updated to work on closed workbooks. | Excel Worksheet Functions | |||
| Using Closed Workbook as Data Book | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| simultaneously work in a work book with other users | Excel Discussion (Misc queries) | |||
| Is there a work around to use the indirct function with a closed . | Excel Worksheet Functions | |||
Linear Mode
