Taking an existing MS Word macro and running it from MS Excel

[EdwardAveyard]

Hello. Let me begin by saying that my VBA skills in MS Word are very limited.

I took the macro from this website to import a series of completed templates into a dashboard in Excel. microsoft office - copy data from multiple word files to excel with vba - Super User

This is working fine. I was wondering if there's a way that I can run this process from Excel rather than from Word. Ideally, my colleagues would go into the dashboard in Excel, and click a button to update the data. At present I need to run this macro in Word to update the dashboard in Excel.

Does anyone know how I can do this? Even something simple would be much appreciated.

Thanks,
Ed