UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How To Extract The Same Data From The Same Position?, Any Version    
 
   
aligator510
post Nov 5 2019, 09:26 AM
Post#1



Posts: 68
Joined: 23-August 17



Hi everyone,

I have a word document with 500 or more pages.
The text in every page is the same exept the adresses and person name which diferent for every page.
I want to extract these data (person name & adress) in an new excel format, keeping the same queue like in the word document.
I appreciate any help!

Thank in advance!

--------------------
Go to the top of the page
 
kfield7
post Nov 5 2019, 11:55 AM
Post#2



Posts: 1,022
Joined: 12-November 03
From: Iowa Lot


Are the pages (name & address specifically) bookmarked?
If not, is there a leading phrase that can be used to find them?
e.g.

Name: John Doe

If so, then VBA could be used to search for the data and populate the Excel sheet.
I would opt to put the VBA in the Excel sheet (as opposed to the Word doc) so you can re-use the sheet/macro as needed.

It would look something like:

Get filename
Open Word doc
do until end of doc
Search for "Name:" using .find, or search for the bookmark
Copy the name to a variable
same for address
write the name and address to the next available row in Excel.
loop
close doc

I left out a lot of particulars, but I thought I'd start with the concept.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    9th December 2019 - 05:47 AM