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

copying cell comment from one sheet to another 2
Sound repeats unending until closing workbook 2
ExecuteExcel4Macro 4
Insert text from Comment in 3/4 TextBoxes in a Form 1
Open four Wbooks, copy four columns from each to Master Wbook 16
Similar Book to Book Code, one works other does not 11
Advice on multiple macros, same code just a different column 9
Code does not error but no copy either 4

Top