Paste Picture Works When Stepping Through (Debug), But Not In Runtime

[Hello World]

I have the following piece of code. Basically what it does is, copying a range as a picture, add a chart object, pasting the picture to the chart, saving the picture, then loading this newly saved picture on the form.
Everything works perfectly fine, besides the 'Paste' action that works perfect when debugging, but not in actual run.

I tried already each and all of the following, with no results:

• Application.Wait
• DoEvents
• Sleep (from the C runtime library)

When debugging through, it takes a second for the paste to happen, so apparently, in runtime as soon it leaves the '.Chart.Paste' line to the DoEvents or Application.Wait line, I lost already the paste action.

Please Login or Register  to view this content.

Is there anything else to do to have the picture pasted and then proceed with the code?

[xladept]

All I can think of:

Please Login or Register  to view this content.

[Hello World]

Isn't working either.

[xladept]

Sorry - that's all I could think of - is the copy working at that stage?

[Hello World]

Yes, copy is working fine, but still not pasting in runtime, only when debugging.

[xladept]

Maybe:

Please Login or Register  to view this content.

[Hello World]

throws error

[xladept]

Uno Mas:

Please Login or Register  to view this content.

[Kenneth Hobson]

For this method, you might want to add a resizing routine.

In the Userform:

Please Login or Register  to view this content.

In a Module:

Please Login or Register  to view this content.

[Kenneth Hobson]

To do it by the chart method:

Please Login or Register  to view this content.

[Hello World]

Wow Kenneth! Simply adding the '.Activate' made it work!
(not sure what you meant to accomplish with the module code before, as just with the .Activate, it works perfectly fine.)

Kinda interesting, as the chart was either way selected and active before pasting onto, so not sure what the Activate helped here, but it helped in fact..
My full code now is:

Please Login or Register  to view this content.

Thanks again Ken!

[Kenneth Hobson]

Activate and Select are sometimes needed for these types of things when one would think not.

#9 uses API methods to use Excel's clipboard contents as the image, not an external file. So, one skips the need for the chart object and the external file.

[Hello World]

Thanks Ken for the extra explanation.