Populate Excel from Word

A

ajayb

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
 
J

JLGWhiz

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.
 

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

Similar Threads

Auto Populate One Pages from spreadsheet 0
Integrating information from Word to Excel (not mail merge) 1
Excel 2003 positioning a cell to first non frozen cell 3
Linking data in MS Word into Excel 5
Call an Excel macro from Word with data 3
Extracting text to from one cell to create columns and rows 1
Mail Merge query 1
Trying to merge a list of names into a Word document 1

Top