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,765 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.
4,154 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,746 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ceasar Chen_MSFT 4,481 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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.