Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Excel from Word
Hi,
I have a number of word files holding FirstName, LastName, MobileNo as form fields. Each of the fields is a bookmark with the appropriate name. I want Excel to look into each document and pull the info into a spreadsheet like so: A B C 1 FirstName LastName Mobile 2 Bob Smith 07777454545 3 John Jones 07536456565 Can anyone help with this? Also would it be possible to do it without VBA? Many thanks Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Excel from Word
1. want Excel to look into each document and pull the info into a
spreadsheet You have to use VBA commands that tell where to find the data in a Word document, but it can be done by someone who works across applications frequently. I don't. 2. Also would it be possible to do it without VBA? You can copy and paste from Word to Excel and vice versa. "ajayb" wrote in message ... Hi, I have a number of word files holding FirstName, LastName, MobileNo as form fields. Each of the fields is a bookmark with the appropriate name. I want Excel to look into each document and pull the info into a spreadsheet like so: A B C 1 FirstName LastName Mobile 2 Bob Smith 07777454545 3 John Jones 07536456565 Can anyone help with this? Also would it be possible to do it without VBA? Many thanks Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling information from Word to populate into Excel | Excel Discussion (Misc queries) | |||
Populate Bookmarkes in a Word Doc. with Excel | Excel Programming | |||
Excel Macro to Auto-Populate a Word Template | Excel Programming | |||
How can I have Excel cells populate a Word label template? | Excel Discussion (Misc queries) | |||
Populate word doc with excel data | Excel Programming |