The attached file provides the code to pull shape data from all shapes on the active page. It is broken down into 3 modules. The main module passes the shapes collection for the active page to the shape searching module. This 2nd module examines each shape on the page, rejects 1D shapes, and ignores shapes with no data. Names of acceptable shapes along with the shape data is stored into a dynamic array. Once all shapes have been interrogated, the third and final subroutine is called to export the data into excel and then reformat the occupied cells on the worksheet.
The file contains three shapes. The 3rd shape has no shapedata. The 2nd page shows the excel file results of the above process for these 3 shapes. The code has a lot of comments. Hopefully that will promote understanding of the subs.
Enjoy
Wapperdude
