nyconfidential
New Member
- Joined
- Jul 22, 2015
- Messages
- 49
- Office Version
- 365
- 2016
Hi all, I'm getting an error message whenever I open up a particular workbook - it asks me to repair, if I say yes I get a dialog box that says "Excel was able to open the file by repairing or removing the unreadable content - Repaired Records: Drawing from /xl/drawings/drawing20.xml part(Drawing Shape)" (Essentially the same problem that was described in this thread: https://www.mrexcel.com/forum/excel...drawings-drawing9-xml-part-drawing-shape.html)
My question is - can I find out exactly which drawing is causing the error? It's a large workbook with lots of drawings - I've tried to loop through all of the shapes objects in the workbook via vba but nothing is actually named drawing20, I'm assuming it's some sort of code name. Appreciate the help, thanks.
My question is - can I find out exactly which drawing is causing the error? It's a large workbook with lots of drawings - I've tried to loop through all of the shapes objects in the workbook via vba but nothing is actually named drawing20, I'm assuming it's some sort of code name. Appreciate the help, thanks.