Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Excel data into specific form areas in a Word Doc
Alright, if anyone can figure this one out, you'll save me a bundle of time and teadious typing:) ! If in Excel, I currently have, let's say the following on row "D" d1 name d2 address d3 city d4 state d5 zip d6 account number And in Word, I have a protected form with 6 text form fields which use the tab button to move from one text form field to the next. So let's say the following is true in my protected form in Word... Text Form Field 1 - name Text Form Field 2 - address Text Form Field 3 - city Text Form Field 4 - state Text Form Field 5 - zip Text Form Field 6 - account number How do I export the Excel data from row "D" to each of the respective Text form fields in the Form I have from Word? Thanks so much for anyone's help on this. -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=534669 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Excel data into specific form areas in a Word Doc
I can see a couple of ways of doing this. The first involves the creation of a Word object and driving the manipulations from Excel Have a look at Controlling One Microsoft Office Application from Another in Excel VBA help. The other way is to use the Application.SendKeys method to send keystrokes to word. -- mrice Reserach Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=534669 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Transferring Excel Data to Word Document | Excel Discussion (Misc queries) | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
Word mail merge with Excel data | Excel Worksheet Functions |