Error 462 - Macro works every 3rd attempt

Now then,

Currently got an issue with a macro button I've set up. The idea is that when clicked it opens a word document then copy and pastes info from Excel (these are linked from the word document so not in the VBA code) into the word document. The issue I'm having is that the macro only works every 3rd attempt. So first time pressing the button I get error 462, the second press nothing happens then on the 3rd press it performs the macro as it should with no errors noted.

This is the code:

Please Login or Register  to view this content.

The debugger picks up an error on the Documents.Open Filename... line but like I say every 3rd attempt it works as it should.

Any ideas would much appreciated. Thanks in advance,

Joe

You need to use code tags when posting code please (put [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end). As soon as you edit your post to include them, we can help you.

Thanks. You just need to qualify the Documents.Open with the application object:

Please Login or Register  to view this content.

Just for debugging purposes you can make it visible - there may be a message on screen in Word:

Please Login or Register  to view this content.

Make sure you end that existing winword.exe process first.

Originally Posted by rorya

You need to use code tags when posting code please (put [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end). As soon as you edit your post to include them, we can help you.

FYI You can also use the #button

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Originally Posted by JoePick87

If we ever meet please remind me I owe you a pint! Thank you very much. Appears to be working perfect!

Duly noted - it's been far too long since I was in Yorkshire!