Can this be done ??  
Author Message
Eddie101





PostPosted: Thu Oct 06 11:22:00 CDT 2005 Top

MS Word VBA >> Can this be done ??

Hi.......as a newby,forgive the ignorance but I ask the question
anyhow........... Is it possible to write a Word macro that will
gather data from another application and open a Word template, placing
that data into the Word document ? If it is possible, is it easy to
write the macro.......any pointers to web sites that offer guidance ?

Many thanks................MNW

Word332  
 
 
Jay





PostPosted: Thu Oct 06 11:22:00 CDT 2005 Top

MS Word VBA >> Can this be done ??
> Hi.......as a newby,forgive the ignorance but I ask the question
> anyhow........... Is it possible to write a Word macro that will
> gather data from another application and open a Word template, placing
> that data into the Word document ? If it is possible, is it easy to
> write the macro.......any pointers to web sites that offer guidance ?
>
> Many thanks................MNW

Partly the answer depends on what the other application is, and how it makes
its data available (if at all). Here are a couple of articles that discuss
the subject for Access and Excel:

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

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org