-
Reading the XML of a workbook
Previously posted http://www.excelforum.com/excel-prog...ml#post5030805
and here: https://www.mrexcel.com/forum/excel-...ml#post5195612
By changing the extension of an xlsm file to .zip and extracting that zip folder we can see a file named "comments1.xml"
Is there a way to read comments from that file without zipping workbook/without opening the workbook? using VBA or any other language?
Or Any other way to read comments from Closed workbook?
The reason I don't want to open the workbook is because there are hundreds of files and will take too much time to open >read comment and close (the files are also xlsm that has a lot of code on opening event
-
If you did manage to open a comments1.xml file, I don't believe you'll be able to read (decode) it, and if you did manage that I'm not sure how you'd associate the data in it with specific Excel cells.
Which is a long way of saying "no".
Sorry
-
The XML in a comments file is relatively simple to parse and includes the cell address and text for each comment. But there will be separate files for each sheet that has comments.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules