copying several Excel files's specific Chart and pasting to the same Powerpoint using VBA

[Prectice]

1. The same Excel files's Sheets , sometimes have 2~3 Chart , but I want to choose the Second Chart on Sheet1 , and , Third Chart on Sheet2 <---How can I do this feature ?

2. The Same PPT files , that's Picture come from several excel files , and , I want the PPT Auto Paste to reach Conjunction effect . such like ： first Excel paste to PPT 1~3 Page , and , second Excel paste to PPT 4~8 Page , and Third Excel paste to PPT 9~13 Page <-- How do I fulfill this effect ??

3. While I paste the Chart to the PPT slide , Can I chose the Slide's Position by VBA automatically? Can I put two chart in one PPT Slide by VBA automatically ? Can I Adjustment the Chart's Size by VBA automatically ?

 

[Jon Peltier]

I don't have time right now for detailed, specific suggestions. However, I wrote a tutorial a while back which may help get you started:

Using Excel with Other Office Applications

 

[Prectice]

I don't have time right now for detailed, specific suggestions. However, I wrote a tutorial a while back which may help get you started:

Using Excel with Other Office Applications

How kind of you , And I want to ask a question , Whether it is possible , to paste more than two chart on the same PPT ??

 

[Jon Peltier]

Of course it it possible. The limit is on how large you want the file to become and how complicated you want any link structures to get.