Using data in Access97 or Excel97 in Words or Excel.

[LimKL]

How to design combo list in Excel/Word to use data in
Access97 ie Name, A/c No.,etc to generate remittance
advice.

 

[John Nurick]

Hi,

These links should help you get started:

http://word.mvps.org/FAQs/InterDev/GetDataFromDB.htm

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

ACC: Sending the Current Record to Word with Automation
http://support.microsoft.com/?id=131583 (Word 97)
http://support.microsoft.com/?id=209976 (Word 2000)

http://www.mvps.org/word/FAQs/index.htm

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476

http://www.mvps.org/access/modules/mdl0043.htm
Opening a new Word document based on a template through Automation