I used Visual Basic in Excel to extract the comments in my table and found it was completely impossible to extract them. In excel365, did it create a new attribute to represent a comment? I sent the file to my colleague, but she couldn't see my comment when she opened the old version of Excel. I would like to ask the technical staff of excel, is this a bug? Or did you change something? If you did it, how should I extract the comments in loop?
Hi, @66050780
I guess the comment you are referring to is the Note in Excel365 now, and the Note in Excel365 was a comment in the old version. For details, please refer to this link: the-difference-between-threaded-comments-and-notes
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thank your answer.it is actually helpful. But i still don`t konw what the attribute of the comment is. If possible, could you tell me? Or , could you provide some example that you or anyone else use the VB to extract the comment? If you do that, iam really grateful！
Regarding properties and how to extract comments using VB, I suggest you wait for a reply from a VB expert, I'm in charge of Office General.
10 people are following this question.
