Opening an Excel document within Word VBA?

L

Lumpy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top