PDA

View Full Version : Copy excel table contain picture shapes to powerpoint



qiyusi
12-11-2014, 03:40 AM
Hello,

Firstly thanks to John Wilson for helping me with my first post question.

I have another problem.

here's the situation:

I have excel sheet,
in B2 = contain picture, in B3 to B6 contain text
C2 = contain picture, in C3 to C6 contain text... this apply to C, D , E column and so on...

my question:

Copy range B2:B6 to powerpoint slides with image still there.
then copy C2:C6 ... and so on, so one slide have 8 tables with images in it ( each tables separate between B, C ,D ..)
so it will loop copying 8 tables contain images ( separate table ) to each slides until last tables with images in excel.

attached the excel and ppt file to understand what i mean.


Is it possible to do that? if not possible, i am thinking about vba code to do:
1. copy 8 pictures to each slide
2. copy 8 tables to each slide

thanks for any help