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.
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.Please Login or Register to view this content.
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
Bookmarks