VBA Image Not Successfully Copying (Intermittent Error)

[Skins11]

Hi All,

I'm getting an error when running a code, but only intermittently. The run-time error code is 4605 (this method or property is not available because the Clipboard is empty or not valid).

The error largely happens at a point where I'm trying to paste an image of a signature into a bookmark in a Word doc. Debug of error below.

Debug Code Screenshot.jpg

The unusual thing is that often this all works fine. Usually after hitting the error, I stop, run again, and it will run successfully. I have also found that it seems to happen more when I'm looping through the code multiple times, and there are multiple documents open. I had wondered whether the copy function is being slowed down and can't operate in time to successfully grab / copy the image perhaps. However I'm really not sure. Just wondered if anyone else had ever encountered this issue, and had any pointers?

Many thanks in advance.

Skins

[ByteMarks]

It is mostly likely a timing issue. Try pausing and/or clearing the clipboard before each operation.

[Marc L]

Or try directly without any useless object variable SigBM# …

[Artik]

I encountered the described problem several times when copying from Excel and pasting into a Word document or a Power Point slide. The tests I performed showed that the second attempt was usually successful. Wait, Sleep, DoEvents did not help to solve the problem.

Try a code construction similar to the following

Please Login or Register  to view this content.

Artik

[Skins11]

Thanks all - adding in a wait of 1 second seems to have done the trick (although does slow this down slightly as it's part of a loop so can add around a minute or two to the process depending on the number in the loop). That said, it's better than having it fail. It seems that you can't add in a wait any less than one second? I also cleared the clipboard between each copy / paste as suggested. Thanks for the suggestions @ByteMarks.

@Mark L - I'm not sure how I would do this directly without the object variable. The images are dynamic (or should I say the reference to the image within the workbook changes depending upon other variables - i.e. if "John Smith" is selected, the signature to send to the Word doc is Picture 3). Unless I'm misunderstanding your point here (which is more than possible)?

@Artik - Thanks for the suggestions. Will give this a go - although will likely need to remove the message boxes as I anticipate this could end up popping up several times throughout the process.

Cheers All

[Marc L]

@Marc L - I'm not sure how I would do this directly without the object variable. The images are dynamic (or should I say the reference to the image within the workbook changes depending upon other variables - i.e. if "John Smith" is selected, the signature to send to the Word doc is Picture 3). Unless I'm misunderstanding your point here (which is more than possible)?

No need to create any object variable to only use it once, waste of time & ressources ! Just use directly the object …

[Artik]

@Artik - Thanks for the suggestions. Will give this a go - although will likely need to remove the message boxes as I anticipate this could end up popping up several times throughout the process.

The Copy2BMK function tries to copy up to 10 times. Earlier I mentioned that in general the second attempt to copy was successful. So I gave quite a reserve. The message will appear only after the tenth unsuccessful attempt to copy the specified signature. So I hope that the message will never appear (although I also had random cases that this method sometimes did not work).

Artik