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.
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.