So I generate a report on a powerpoint template with almost 150 slides. The data is brought in from excel and when I first made the macro I didn't bother to actually label the ppt slides and then use that label as a reference for where certain values on my excel sheet should be brought in. Instead my excel to ppt macro just brings in data from excel to slide 10 and then 11, etc.
As I have done this report for awhile now some slides are no longer relevant but I still have to have them in there because if they're not then excel will bring in data to the wrong slide. So the way that I've been handling it is that after the data is brought in I just disconnect the ppt from the excel file and then delete the slides that are no longer relevant and then move around the slides whose order has changed. In order to automate this process and make this part of the report creation process more flexible I was hoping to come up with a macro that would label the slides in VBA. What I've found online so far is below. What I was now wondering is how I would reference effective later on in the VBA module. So for example in Sub Page deleter, I am currently using the activewindow.viiew.gotosli
de index formula, but I was hoping that there is a formula which would reference the tag I gave to slide 8 instead.
.Tags.Add "effective", "6"