K
Kathy
Hi everyone,
My client created a lot of drawing files (more than 20000 files)
programatically. Because of the errors in the codes there are many shapes
that are referencing custom properties in the other shapes that does not
exist.
I need to fix this by scanning the shapes, checking if the shapes they are
pointing exists, and delete the reference if they don't exist. I first
tried to use CellExist for the referenced shapes, but I hit the error,
because I was trying to access execute the CellExist for the shapes that
don't exist.
I am using VBA...how I can tell that the shape, for example Sheet.X does not
exist in the file?
Thanks!
My client created a lot of drawing files (more than 20000 files)
programatically. Because of the errors in the codes there are many shapes
that are referencing custom properties in the other shapes that does not
exist.
I need to fix this by scanning the shapes, checking if the shapes they are
pointing exists, and delete the reference if they don't exist. I first
tried to use CellExist for the referenced shapes, but I hit the error,
because I was trying to access execute the CellExist for the shapes that
don't exist.
I am using VBA...how I can tell that the shape, for example Sheet.X does not
exist in the file?
Thanks!