L LimKL Apr 28, 2004 #1 How to design combo list in Excel/Word to use data in Access97 ie Name, A/c No.,etc to generate remittance advice.
How to design combo list in Excel/Word to use data in Access97 ie Name, A/c No.,etc to generate remittance advice.
J John Nurick Apr 28, 2004 #2 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
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
