Rare bug when copy pasting picture from 1 workbook to another

[Andrew87..]

Hi all,

I occasionally run into a bug when copy pasting picture from 1 workbook to another

Currently i use this solution, I paste in a newly created worksheet in a loop, so for each loop the picture is pasted to the new worksheet. It does work in 99% of time but sometimes the last line WS_Temp.paste doesn't work. When I return from error handling back to the line and resume it, it works.

Please Login or Register  to view this content.

before I have used this solution with the same results:

Please Login or Register  to view this content.

Would you please know some workaround or solution for this?

Many thanks!

[davesexcel]

You should show how you have dimmed the variables.

Your title reads "...from 1 workbook to another ", you don't mention workbooks in the question.

[Andrew87..]

Hi Dave,

my apologies. Here it is:

Please Login or Register  to view this content.

Setting:

Please Login or Register  to view this content.

At the end of each loop I have:

Please Login or Register  to view this content.

[davesexcel]

I see

Please Login or Register  to view this content.

Does the code know what ".Range("B2")" is? Or maybe it thinks it is a different sheet? You have a period before range, this would mean you have qualified the range with a sheet.
for example:

Please Login or Register  to view this content.

[Andrew87..]

Hi,

that was my previous solution and you are indeed right about that, I had an incorrect reference there, however my current solution is:

Please Login or Register  to view this content.

Here it should be clear.

[davesexcel]

I thought my previous post was the solution, if not, you may have to supply a sample workbook ....

[Andrew87..]

Hi,

got it thank you, so I implemented your solution now:

Please Login or Register  to view this content.

I have tested it on my range in loop, out of 150 it failed twice. I suspect it must have something to do with pasting the picture from 1 sheet (another workbook) to another. After the bug simple resume continues the code without any issue. I think some delay could potentially fix it, or i will try to copy it only once and keep it on the temp workbook during all loops just manipulating the location each time.

The error I forgot to mention from errorhandler is:

Paste method of Worksheet class failed 1004

[davesexcel]

Just an FYI, if you have a picture in a range, you can copy the range and the picture will paste with it.
-
-

PictA1E7.JPG

-
-
The code will copy the range, including the picture and paste it where you need to.

Please Login or Register  to view this content.

[Andrew87..]

Hi,

thanks for this tip. For now I have solved it by loop and count of shapes within the sheet. While testing it the paste failed on 3 occasions but on the 2nd attempt in the loop it worked so I think this is an ok workaround for what seems to be a bug.

Please Login or Register  to view this content.