VBA opens word then keeps trying to open the same document

[lightning_storm]

Hi
I have a macro that will open a word document and copy information from excel to a table in the document. I can create a new word document that is blank, and transfer data but whenever I try to open an existing document, excel keeps opening the document. This causes the document I want to open, then the same document with a read only warning to open. if I cancel this then my code fails with runtime 4198 and highlights the open document line.

Please Login or Register  to view this content.

If I try opening the document and include a ignore read only command then it will continue opening versions of the same word document until I close it on task manager.
If I remove the document and only try to create a word application it does the same thing.

I have tried various coding methods to open word, and documents, and this happens every time.

I'm on a networked computer in my workplace but both local and network versions cause this issue. Is there something corrupted, or another issue in excel or word?
Or am I just missing something really obvious.

Any Help would be much appreciated
(I'm teaching myself VBA, slowly, through trial and error. I may not understand you if you get too technical )
Thank You

LS

[macropod]

There is nothing in the code snippet you posted that would cause the described behaviour. Of course, if that code's inside a loop (or is being repeatedly called by code in a loop), that would explain it. I note also that your document is in the docm format, which implies the document contains macros of its own. Those, too, might have some bearing on the matter.

[lightning_storm]

I've tried writing the code in a new excel document on its own with no other code, ams replaced the document with a regular .docs
IT still tries to open it several times. Thanks for your suggestions though.

[macropod]

In that case, I'd be looking into the macro(s) in the document you're opening.