Error when trying to access data for RegionMap chart type

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:

Code:

---

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!

Have you tried activating the chartdata first?

Code:

---

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

---

Quote:

---

Originally Posted by Andy Pope

Have you tried activating the chartdata first?

tunnel rush

Code:

---

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

---

---

Can you explain this part specifically?

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