Have the comment attribute of excel365 changed?

鑫珑 王 1 Reputation point
2022-06-21T04:40:10.257+00:00

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?

VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,564 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,458 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ceasar Chen_MSFT 4,391 Reputation points
    2022-06-21T07:43:34.48+00:00

    Hi, @鑫珑 王
    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.