Populate Excel from Word

  • Thread starter Thread starter ajayb
  • Start date Start date
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
 
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

Extracting text to from one cell to create columns and rows 1
VBA Help 2
Call an Excel macro from Word with data 3
Help on Excel-Word project 4
Excel spreadsheet to Word document 1
Help with macro to populate blank values 2
Extracting from string 9
Populating values in cells based on lookup from other cell. 4

Back
Top