Each worksheet to Powerpoint Slide

[rrocker1405]

Dear Team,


I've shared a sheet as an example. I would like to know how to create the following ranges of this sheet to powerpoint slide using vba?


range1 = Sheetname(Table1).Range(a1:c4)

Range2 = Sheetname(Table1).Range(F1:H4)

Range3 = Sheetname(Table2).Range(a1:C4)

Range4 = Sheetname(Table2).Range(F1:H4)

Range5 = Sheetname(Table3).range(a1:c4)

Range6 = sheetname(Table3).Range(f1:H4)


I have created slides if the tables are in same sheet however I'm not able to create slides if the ranges are in different sheets. could you please help.


https://skydrive.live.com/redir?resid=52CEA967A17FE43E!2678&authkey=!AL3pGAxIjBPEyFs


Thanks in advance, Regards.

 

[Hui]

Have you had a read of: http://chandoo.org/wp/2011/08/03/create-powerpoint-presentations-using-excel-vba/

 

[rrocker1405]

Yes, I have already. The solution states only for all data under one sheet to powerpoint However what if there are multiple worksheets like the one i had shared. I'm not able to set ranges. Could you please help.


Thanks in advance. Regards.

 

[rrocker1405]

Hi team,


Would be grateful if you could help me solve the request.


Thanks in advance. Regards.