I can read all comments in excel file using below code. How do I read left side cell value to the comment cell?
Please Login or Register to view this content.
sample data:
A B C Col B comments
---------------
a1 b1 c1 b1 comment
a2 b2 c2 b2 comment
expected output:
------------------------
left side cell val Col B comments
----------------------------------------------------------
a1 b1 comment
a2 b2 comment
Please find attached test.xls for sample. Thanks.
gsr
not to sure what you need but this will show the comments
Please Login or Register to view this content.
I wanted to read left side cell value while reading comments from the worksheet. For example, when code reading Cell D3 comment, I also wanted to read value in the cell C3. When reading cell D4 comment, I wanted to read value in cell C4. Please find attached attached test.xls file to my first post, Sheet "Before" has input data. Sheet "After" shows expected data to be extracted from Sheet "Before". Thanks.
Do you know where all the comments are?
try this
it comes from the vba help but I cant get in to work #@#$%Please Login or Register to view this content.
Thinking is that if you can select the cell you can find its address then the offset value
Not pretty but does the job
Please Login or Register to view this content.
There are lot of sheets in workbook and most of the sheets has bunch of comments. I used below code to read all the comments in workbook.
However, I need to read cell value along with comments.Please Login or Register to view this content.
ex:
column next to the comment cell
2 columns over from the comment cell
Range("E9:G17") - would this look through entire sheet.
myCell.Comments.Shape.Visible - what this line checks for?
Thanks.
Last edited by gsr; 05-15-2010 at 10:58 AM.
Code tags, dude, can you add please code tags to you posts
Last edited by pike; 05-14-2010 at 06:33 PM.
Pike,
code you posted works fine within workbook. I'm actually reading comments from another workbook. I modified your code to read from another workbook, I got error at below line, seems like, myCell.Comments is null.
Is there something I have to change in code?Please Login or Register to view this content.
Also, I'm getting error while closing workbook.
is it possible to read comments without opening workbook?Please Login or Register to view this content.
code to read comments from another spreadsheet:
----------------------------------------------------------------------
Thank you.Please Login or Register to view this content.
Last edited by gsr; 05-15-2010 at 01:41 PM.
Hi gsr
Theas The syntax will away be an error unless the cell contains a CommentPlease Login or Register to view this content.
pike,
I'm getting runtime error while closing workbook. I tried adding error handling "on error resume next", however, everytime excution breaks at wbk.Close line. Seems like, workbook is closing when I stopped/end run mode. Can you please suggest how to handle this error.
Run-time error '1004'Please Login or Register to view this content.
Application-defined or object-defined error
Thanks.
Can you first create and collate an array of all the workbook values then
print it to the txt file?
other wise it not a good option as it uses errors and will err on nearly every cell
can you point me to a reference or plz post some code if possible.
If I collate an array of all the workbook values, wouldn't be an issue while closing workbook?
Thanks.
you could add the values to current workbook sheet then print form it?
dude,
This works for me
Please Login or Register to view this content.
Last edited by pike; 05-16-2010 at 01:31 AM. Reason: SaveChanges:=False
This works for me
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks