Opening Excel from Word

[jarnold231]

Good evening. I'm hoping someone here can give me some help with what I assume is a relatively simple VBA programming challenge, but which is well beyond my VBA capabilities.

I am trying to create a macro that performs the following actions.

1. User opens .docm Word file
2. VBA automatically opens a referenced
3. Excel File The Excel file runs a Private_sub (this is all working)
4. User answers a Application.Input box in the Excel Word document updates all links from Excel File
5. Word requires the user to SaveAs the Word document

I understand that the VBA needs to be embedded in the Microsoft Word Objects "ThisDocument" section of VBA. I've tried a number of scripts that I've found online which include the use of Objects (things like Dim excelApp As Excel.Application), but I always get a runtime error.



Really hoping someone can give me a bit of an idiots guide to getting the basic structure of this set up.

Any help greatly appreciated.

Jake