Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading Comments in a closed file
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").valu e = a end sub anyone have an idea Thanks Kurt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading Comments in a closed file
Why not just open the first workbook and copy & paste/special/comments??
-- Gary''s Student - gsnu2007k "kurthh" wrote: 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").valu e = a end sub anyone have an idea Thanks Kurt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading values from a closed workbook | New Users to Excel | |||
reading and modifying file comments | Excel Programming | |||
Reading from a closed workbook | Excel Programming | |||
Reading from a closed file. | Excel Worksheet Functions | |||
Reading Sheet Names/Index from closed file using Biff8. | Excel Programming |