Excel macro that loops through slides of a PowerPoint presentation and changes the data for numerous charts.


Macro works perfectly fine until it comes across a shape where .Chart.ChartType=xlRegionMap


Code where I get the error:
Set wbk = Sh.Chart.ChartData.Workbook

Again, this line works fine for every other type of chart except a region map. Anyone know why this is, and have a workaround?


Any help is much appreciated!