kvb
11-02-2006, 12:29 PM
Hi All,
I need to cycle through 1,000 workbooks and replace a specific shape within those workbooks. However the name of the shape changes from one workbook to another. The shape is always in the same location. Is there some way that I can select a shape based on it's location on the spreadsheet. I have looked at ZOrder, but it is not consistent for me.
I could create a range and select all within the range, but am unfamiliar with the syntax.
This is a company logo that I will remove and place a new one in its place, when I insert the new one, I will give it a specific name, to make the modification easier in the future.
Thanks
Ken
I need to cycle through 1,000 workbooks and replace a specific shape within those workbooks. However the name of the shape changes from one workbook to another. The shape is always in the same location. Is there some way that I can select a shape based on it's location on the spreadsheet. I have looked at ZOrder, but it is not consistent for me.
I could create a range and select all within the range, but am unfamiliar with the syntax.
This is a company logo that I will remove and place a new one in its place, when I insert the new one, I will give it a specific name, to make the modification easier in the future.
Thanks
Ken