Word VBA "Lumpjaw" <moc.swen[ at ]news.com> 12.09.2006 23:26:37 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. -- A response to the newsgroup will allow us all to learn from your expertise! -Lumpjaw

Re: Word VBA "Jean-Guy Marcil" <NoSpam[ at ]LeaveMeAlone> 13.09.2006 00:14:11 Lumpjaw was telling us: Lumpjaw nous racontait que : [Quoted Text] > 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. 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 jmarcilREMOVE[ at ]CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org