Copying Excel sheet to Powerpoint with VBA

[RLN]

RE: Excel 2007/Powerpoint 2007

I have an Excel file with 30 tabs. Each tab has data and some
graphics (no charts though). The range on all tabs is from cell A1 to
Q50, although that can change with next months data. I would like to
transfer each of the 30 tabs to 30 slides in a single PPT deck. I got
a macro started to copy the data from the sheet, but am unsure how to
paste to PPT.

I need to:
1) copy each sheet in the above range and paste to an individual
slide.
2) position the paste to be in the upper left hand corner of the
slide.
3) expand the pasted object to "fit to slide"
4) take the title of each tab (ie "Tb3.1", Tb3.2", etc....) and put
those in the bottom right hand corner of the slide, say with a 10pt
Arial font.

Can this be done in VBA and if so, does anyone have a code sample
shell of how to do this?

many thanks,

 

[Daniel Jones]

RE: Excel 2007/Powerpoint 2007

I have an Excel file with 30 tabs.  Each tab has data and some
graphics (no charts though).  The range on all tabs is from cell A1 to
Q50, although that can change with next months data.  I would like to
transfer each of the 30 tabs to 30 slides in a single PPT deck.  I got
a macro started to copy the data from the sheet, but am unsure how to
paste to PPT.

I need to:
1) copy each sheet in the above range and paste to an individual
slide.
2) position the paste to be in the upper left hand corner of the
slide.
3) expand the pasted object to "fit to slide"
4) take the title of each tab (ie "Tb3.1", Tb3.2", etc....) and put
those in the bottom right hand corner of the slide, say with a 10pt
Arial font.

Can this be done in VBA and if so, does anyone have a code sample
shell of how to do this?

many thanks,

Check out Jon Peltier's website (linked below). he has an awesome
page about using excel with other office applications.

http://peltiertech.com/Excel/XL_PPT.html

 

[Ron Nolan]

Thanks! I appreciate the quick response!