Hi!

I have already posted this question here, but I haven't got any answer sofar.

I am having problems opening a Word document from Excel file. I am using the code below to open a Word document. 

Sub open_word()

Application.StatusBar = "Please wait."
Set wordapp = CreateObject("word.Application")
wordapp.documents.Open "C:\Users\username\OneDrive\WordFile.docm"
    
    wordapp.Visible = True
   
End Sub
In this Word document (which I'm using as some kind of report file), I have links to data in the Excel file. These links are updated when I open the Word file, and this works fine.
The problem is that when I run the above code, additional copies of the original Excel file are created (at least I think so). These copies do not open and are not visible in the Excel application. However, when I close the original Excel file, the Excel always asks if I want to save the changes for those copies as well. I have also noticed that additional projects (always 9 additional projects) are created in the Visual Basic Editor (please see the below picture).

1651142944260.png

I would like to know why this is happening and how can I prevent it?