Printable View
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!
Excel is different from Powerpoint in its naming convention. In Excel vba you need to refer to the workbook first, then the chart object
Thank you for the response. I get that. My point is, what I have for code currently works for every single chart type EXCEPT a RegionMap. So it seems my syntax is fine, but I just can't seem to figure out why it won't work for that one chart type.Quote:
Originally Posted by Aussiebear
I think this is yours:
https://www.reddit.com/r/vba/comment...aworkbook_for/
another topic from reddit:
https://www.reddit.com/r/vba/comment...aworkbook_for/
you may consider Khazahk's reply:
or you may include "On Error Resume Next" in your code and do the RegionMap stuff manually.Quote:
The region map probably doesn’t have the “chartdata”property.
Check the object library and see what makes RegionMaps different. Could be a property called “RegionData” and the. Perhaps you can call the workbook from there.
You would simply throw in an If statement. If Charttype = regionmap then do it this way else do it the other way end if.