Any way to maintain slide source format when copying using Visual Basic?

[wessel]

I have written up a code that is able to (from Excel) locate and copy a specific slide and put it into a new presentation. The problem is that it does not copy the same format. I tried simply ending the code in PasteSpecial instead of just Paste, but that apparently does not work. I am not copying just one image or chart. I want to copy everything, including the source format. If I manually copy and paste, there is always a tool that pops a that I can click to make it keep the source formatting. But that doesn't pop up if I use code. If you have any ideas I gladly welcome them! (Or if you happen to know another method that would automatically apply this format, with or without applying it to all new presentations, that would be fine as well.)

Thanks!

[westconn1]

with pastespecial you have to provide the correct arguments for the desired result

lookup in the help for powerpoint (not excel) to find what arguments are available for its pastespecial method, or look here
http://office.microsoft.com/en-us/po...010117115.aspx