This thread needs to be moved to the VBA forum.

Yes, but it will still require the Word application to run and each document in turn to be opened, updated, saved and closed.

The code to do this is largely the same as it would be if you did it from Word.

Just realised you're using macOS.
Find a Windows machine to use if you need to run this from Excel. The ability to automate another Office application using VBA is fundamentally broken on macOS.