Does anyone know a good resource for getobject and createobject for ms word controling excel. I need this to get the sql and odbc functionality. Word seems to cope with sql through mailmerge only and I’m not able to use this due to multiple tables on the database. please help.
you may want to try Microsoft ActiveX Data Objects 2.8 Library and the ADO 2.8 objects (very useful when it comes to connecting word to a database ie SQL) and Microsoft Excel Objects Library when you want to control Excel from Word.
To do so you need to reference it : from the visual basic editor (ALT+F11) click Tools and Reference and scroll down till you can find “Microsoft ActiveX Data ” and tick it. Do the same for excel library.