Hey Dave, I mentioned a few posts back after being given a polite 'nudge' by Sam that I'd ditched the 'load two Excel table's data into TextBox' routine.

Anyway, yes I do have the four worksheets in Triage.xlsm

Although the link you have provided certainly provides a possible solution, I'd really prefer to use Word as the driving program, as the Excel data is only a small part of the form data that the user requires to put into the document.

I cannot see that the code can be too far off, there must be something really "simple" that needs adding or altering.

I've obviously checked that I have the Microsoft Excel 16.0 Object Library selected!