macro for excel and powerpoint

Hi,

Is it possible to build a macro that copies charts from excel and paste them into a powerpoint file ? If yes, how.

any help is greatly appreciated
thx
marius

I found this just the other night. As mentioned you need to give the macro the reference to the Powerpoint libraries. See note in comments, in the Visual Basic editor select Tools, then Reference and then scroll down the list until you find "Microsoft Powerpoint....".

You also have to provide the plot number to copy, this example it was plot #2 on the page. I have only been using for a few days, but working fine for me.

You call this from your macro with the line below

Copy_Paste_to_PowerPoint

Hope this works for you

Please Login or Register  to view this content.

Thank you so much.
Sorry it took me so long to answer you.
mariusescu