Hardeep, take a look here 'Automates copy/paste from Excel to PPT -
Presentation Helper' (http://tinyurl.com/djod6e) it will help you a long
way towards your goal!

hardeep.kanwar;304474 Wrote:
HI! Experts

Is it possible with macro to Copy Chart and Range from the Sheets to
PPT

Means, i have one Workbook With 150 Charts and there data in Different
Sheets that means 150 sheet in a workbook.

Note- Sheet 1 data Range is A1:B10. I make the Pie Chart in the Same
Sheet.

My Chart in the Same Sheet in All Sheets i.e 150 Sheets

Now, i want to copy these chart and range and Paste into PPT.

Chart will Paste to ( Click to Add Title ) portion.

And Range Will Paste to (Click to Add Text)

Is it Possible with Macro or VBA or i have to go Manually

Thanks In Advance

Hardeep kanwar


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=85137