I've had a lot of help in this forum about connecting my Word VBA to an Excel workbook using Windows 7 and Office 2013, both in 32 bit, and am I'm very grateful for the tips and guidance from a large number of experts.

However, my client is now upgrading to Windows 10 and Office 2016 both 64-bit. I now need to connect to, and read, an Excel workbook range from Word VBA macros.

What are the connection methods I can use now with these updated systems and what might be the best method of achieving this, please?

Any particular sites which might support the information provided?

Thanks for any help