Copy Data from Excel to Powerpoint in VBA?

[newcoder]

Hello
I have been working most of the day trying to get Excel to talk to PowerPoint. I am on Version 2007..

What I want to do is run a macro in Excel, have that macro copy a few columns then .COPY so it will be in the clip board.
I then want to switch to PowerPoint and Paste-Special as a Windows Meta File.

Does anyone have a short code snipit perhaps they could share?

cheers

 

[Derek Brown]

The following link may give you the answer:
http://peltiertech.com/Excel/XL_PPT.html
In particular, look in the page for "Paste a Selected Excel Worksheet Range into the Active PowerPoint Slide"

 

[newcoder]

thanks!

 

[newcoder]

Thank you very much.........
If was able to find the code and actually get it to work!!

thanks...

I do have one question on it and I hope someone can help.

I would like to upload the code snippet, but I don't know how to do that without pasting it all a inline text and I don't think that is what you are suppose to do.

The section I need help with is:
ActiveSheet.ChartObjects(iCht).Chart.CopyPicture _
Appearance:=xlScreen, Size:=xlScreen, Format:=xlPicture

This copies chart by chart. I actually have 4 charts on the page and just want to copy all of them, not iCht.

Is there a way to do a select ALL then CopyPicture?

cheers

 

[Derek Brown]

Here are two llinks that may be useful:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=370
http://www.ozgrid.com/forum/showthread.php?t=57762&page=1