Error when trying to access data for RegionMap chart type

[mbraun]

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!

[Andy Pope]

Have you tried activating the chartdata first?

Sh.Chart.ChartData.activate
Set wbk = Sh.Chart.ChartData.Workbook

[MuriceHunte]

Have you tried activating the chartdata first?

tunnel rush

Sh.Chart.ChartData.activate
Set wbk = Sh.Chart.ChartData.Workbook

Can you explain this part specifically?

[Andy Pope]

On a standard chart this would activate the data sheet, where the values are stored