Bhatti1981
12-22-2018, 12:38 AM
Previously posted http://www.excelforum.com/excel-programming-vba-macros/1256823-reading-the-xml-of-a-workbook.html#post5030805
and here: https://www.mrexcel.com/forum/excel-questions/1081407-reading-xml-workbook.html#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
and here: https://www.mrexcel.com/forum/excel-questions/1081407-reading-xml-workbook.html#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