Hi there, I am having an issue with the loop order through my active worksheet when exporting several charts to powerpoint. The code does select and export all of the charts to slides as is expected, however I shifted one of the charts further down my sheet, yet when the code runs, it still picks up this chart in the original order in which it was placed. Basically, it was the second chart on the sheet, and hence copied to Slide 2, and now that it is further down the sheet, is still copying to slide 2. All of the Charts are named uniquely, and it is not an alphabetical problem. This is a bit of a problem as i have a lot of formatting i need to do in terms of final number and order of slides, and I dont want to have to name specific charts to specific slides as this becomes a nightmare. As of now, this is all a result of having to perform workarounds to transfer graphics initiated in Access data, which then exports to excel for analysis, then to ppt to achieve emf format before finally been sent to word for the report.
Is there somewhere that a chart index can be edited in terms of defining order in which these charts are copied??