question

66050780 avatar image
0 Votes"
66050780 asked CeasarChenMSFT-3458 commented

Have the comment attribute of excel365 changed?

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?

dotnet-visual-basicoffice-excel-itprooffice-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CeasarChenMSFT-3458 avatar image
0 Votes"
CeasarChenMSFT-3458 answered CeasarChenMSFT-3458 commented

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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!

0 Votes 0 ·

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.

0 Votes 0 ·