Hello,
earlier in Excel you were able to adress a comment (now known as note).
with Offfice 365 comes a new function: threaded comments.
to work with them is good and easy but I'm not able to adress them via VBA or to be more specific: to read them via VBA.
I only find - with help of the makro-recorder - the new name for it.
Could someone help me to read the text of the treaded comments?
Please Login or Register to view this content.
greets
Marc
I don't believe the object is made available to VBA.
You can check the object and it's members by going to Object Browser, Right-click, "Show Hidden Members".
However, even when recorded macro is run, it will produce error. I tested bunch of different parent object. But was unable to access it using any number of methods.
Likely it isn't meant for use via VBA at this point (since it's relatively new).
If you need to read the content of threaded comments. You could read the underlying xml using PowerQuery or some other method.
You can find example in thread below.
https://www.excelforum.com/excel-pro...ml#post5037804
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thanks, that help me a lot.
I hope it will be someday available in VBA.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks