reading Comments in a closed file

K

kurthh

Hi
I need to read the Comment Text in the first workbook and place the
comment in the second workbook without opening the first workbook
I expet the macro running in the second workbook.
I have been trying this
sub ( conn()

a = ExecuteExcel4Macro("'\[first.xls]sheet'!" & Cells(1,
1).Comment.Text(, , xlR1C1))

workbook(second).sheets("Sheet1").range("A1").value = a

end sub

anyone have an idea

Thanks

Kurt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting URLs in comments to Markdown-formatted links 2
copying cell comment from one sheet to another 2
Sound repeats unending until closing workbook 2
Advice on multiple macros, same code just a different column 9
Open four Wbooks, copy four columns from each to Master Wbook 16
Similar Book to Book Code, one works other does not 11
Sub projects added as read only in Master file which are saved on sharepoint 1
Code does not error but no copy either 4

Top