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!