Fill Chart Area from Clipboard using VBA

There is a Clipboard button in the worksheet dialog
Format Chart Area>Fill>Picture or Texture Fill > Insert from Clipboard.

What is the VBA syntax for doing this?
Regards
Brian
canesbrAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
I don't believe there is a direct equivalent. I think you have to create a file from the clipboard contents (using code like Stephen Bullen's PastePicture) and then assign that as the UserPicture
canesbrAuthor Commented:
Yeah, I saw the big ugly code. That's why I am looking for something simpler. I'm thinking of invoking PowerPoint's functionality of saving an image to file. Do you know if that is doable?
Excel VBA copy>invoke ppt>Ppt/excel(?) VBA paste to ppt slide>ppt save image to file>
Regards
Brian
Rory ArchibaldCommented:
Probably but I can't imagine why you would do that instead.
canesbrAuthor Commented:
Don't want the fight to get the Bullen thing working.
Rather want to learn how to do the ppt thing - the hand off, the vba, the hand back.
Regards
Brian
Rory ArchibaldCommented:
The PastePicture code is a self contained module (i.e. you just plug it in and use it) and I think would be far more efficient than automating PowerPoint.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.