How can I make database connectivity (Access and Excel) in Microsoft Word
VBE. If possible please give me one sample code.
Chuck - 06 Apr 2005 18:01 GMT
Look up "DAO" in Word help (DAO = Data Access Object). That will explain and
give an example...
> How can I make database connectivity (Access and Excel) in Microsoft Word
> VBE. If possible please give me one sample code.
Perry - 06 Apr 2005 22:29 GMT
Look here
General information regarding Office automation
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/h
tml/office05042000.asp
Following URLs contain sample code
Excel/Word
http://word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm
Access/Word
http://word.mvps.org/FAQs/InterDev/GetDataFromDB.htm
Outlook/Word
http://word.mvps.org/FAQs/InterDev/ControlOLFromWord.htm
Krgrds,
Perry
> How can I make database connectivity (Access and Excel) in Microsoft Word
> VBE. If possible please give me one sample code.