Opening a Word document from Excel file creates (hidden?) copies of excel files

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.

Please Login or Register  to view this content.

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?

I don't have any other code in the workbook. In the Word file, I have a macro that updates the links, calls the macro to export from word to pdf, and then closes the word. The code is like this

Please Login or Register  to view this content.

As far as I can see (but I'm not a VBA expert!), there is nothing in the code that would cause the described behavior.

Sorry for the late response, I was away from the computer for a few days.

Originally Posted by CheeseSandwich

Hmm that is strange, Have you got anything listed in the Excel: 'At startup, open all files in:' box settings?

You can find it in: Options/ Advanced/ General section

I checked the settings and there is nothing in the box.

Could this behavior be due to the fact that I recently moved both files to the OneDrive folder so I can access these files on different computers?