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