Word VBA

L

Lumpjaw

I am working on a Word document that has a built in userform. The userform
prompts the user to input some data, the data is then written to various
other Word documents. What I want to do is open an Excel and write the same
data to a specific cell in the doument. Here is the scenario.

Word Document "New Job" prompts user to input "JobName"
Word Document "Project" receives the JobName information and then closes
Word Document "Company" receives the JobName information and then closes
I want Excel Document "Tracker" to open copy the JobName data to sheet1.
cell 'A1' and then close

This all happens from with in Word VBA, how can I copy this info in to the
Excel Document. Thanks.
 
J

Jean-Guy Marcil

Lumpjaw was telling us:
Lumpjaw nous racontait que :
I am working on a Word document that has a built in userform. The
userform prompts the user to input some data, the data is then
written to various other Word documents. What I want to do is open
an Excel and write the same data to a specific cell in the doument. Here
is the scenario.
Word Document "New Job" prompts user to input "JobName"
Word Document "Project" receives the JobName information and then
closes Word Document "Company" receives the JobName information and
then closes I want Excel Document "Tracker" to open copy the JobName data
to
sheet1. cell 'A1' and then close

This all happens from with in Word VBA, how can I copy this info in
to the Excel Document. Thanks.
Click to expand...

For a start on this, see:
http://word.mvps.org/faqs/interdev/controlxlfromword.htm

Post back if you have specific questions.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
[email protected]
Word MVP site: http://www.word.mvps.org
 
Top