Home » Forums » Open Source Learning Center » Question and Answer

Copy a range from excel to ppt as a bitmap

Submitted by sr777 on 19 October, 2011 - 19:40

Hi All,

Here is my challenge which i'm facing

1. I have a validation with a list of values which are linked to set of graphs
2. I select one of the options and then the graphs change dynamically
3. I now need to copy the range(not individual graphs)to ppt as a bitmap and loop it through the list of values in the validation. Which means if there are 10 values i need to have a ppt with 10 slides.

Can any one help?

Regards
SR777

‹ Maximum Absolute value with same sign Nesting formulas from a Query ›
»
Nick's picture

excel to ppt

Submitted by Nick on 19 October, 2011 - 20:26.

So you want to copy a range of cells to ppt ?
- simply copy the cells, then in ppt go Edit => paste special => bitmap. (or png)

»

Copy a range from excel to ppt as a bitmap

Submitted by Anonymous on 20 October, 2011 - 13:35.

Well Nick i am looking for a vba code for the same.

»
Almir's picture

Why don't you link Excel file in .ppt?

Submitted by Almir on 23 October, 2012 - 22:37.

Why don't you link Excel file in .ppt and make changes directly in presentation?

»

range to powerpoint

Submitted by Anonymous on 23 October, 2011 - 07:48.

take a look at this tip:

http://excelexperts.com/Export-Excel-Charts-to-PowerPoint

..it's close to what you're after

»
Vishesh's picture

Slight change to the code on

Submitted by Vishesh on 29 October, 2011 - 14:13.

Slight change to the code on the above url

Just put these copy paste statement and comment out the ones already there for charts.

Worksheets(SheetName).Range(RangeName).Copy
ppSlide.Shapes.PasteSpecial(ppPasteDefault, link:=RangeLink).Select

»