Then again, I have very little experience with VBA, so I might be completely missing the point and there is a super simple solution I am just not aware of. I have searched for solutions online but I did not really find anything, which I found odd, since it seems like a pretty common thing that someone would do with VBA. Note that the only files in the folder are the 3 documents and the spreadsheet, and the program does find the files without any problems.

Set WordDoc = (Filepath) 'This produces the error Set WordApplication = CreateObject('Word.Application') Here's my Excel Macro code: Sub LoopThroughFiles()

'Excel is waiting for another application to complete an OLE action.'Ĭlicking ok and waiting does not help because the error message reappears after a few seconds, and the only way to stop it is to manually kill the Excel process. I also tried to update the Word documents directly from the spreadsheet, but that does not work either, because when Excel tries to open a Word document via VBA the program stops executing and trows this error: Here's my code for that: Sub UpdateFields() I tried to automate updating all fields in a document from Word with VBA, but that has the same problem, it also brings up the Macros dialog constantly for half a minute. So updating the link works, but only if you're willing to click the 'activate Macros' button of a few dozen times.

It doesn't do this just once but constantly during the 20s or so the update process takes (which seems unusually long to me). When trying to update a link in Word by right-clicking on it and selecting the 'update link' option it brings up the Macro warning dialog for the spreadsheet, asking whether I want to activate Macros or not. The spreadsheet has some Macros in it which auto-update parts of the spreadsheet internally.Įverything is working fine, except for updating the links in the Word documents. I am trying to automatically update certain information (such as names, dates and numbers) across 3 different Word documents by putting the data into a spreadsheet and linking to the respective cells from Word.

Word 2016 upgrade macros