PowerPoint 2003 VBA - shape names
Posted on 2009-05-05
Pretty quick and simple... I have data in an Access database that I'm tyring to DAO out into pre-existing tables in PowerPoint (2003). Formatting adustments may need to be made to the tables also.
Bottom line...PowerPoint shapes (names) are driving me nuts as they seem to change when I alter some part of the table - i.e., in the PPT file, I may have (example) a table called "Group 22". Fine. However, say I select a cell or two and apply a fill. When I go back out and select the whole table and pull the shape name, it's now "Group 23". ??? Adding a fill to another cell - name is now "Group 24". Change the border on one of the cells = "Group 33". Merge a couple cells = "Group 36".
I need these tables to stay fixed so my code can deal with them. I saw a similar posting on here, but the Experts couldn't reproduce the problem and the user developed a workaround. I actually worked around this on a previous project by creating the tables from scratch first -which I can't do here as there are 30+ pages of them and the formatting is quite complex.
I have tried assigning names to them in VBA, but still get the name-change issue once I change any part of the table's formatting. Do PowerPoint objects have any sort of Tag property (like Access controls) that can be referenced instead?
Any other ideas, tips, suggestions and/or answers are greatly appreciated. Thanks much!