My Assistant
![]()
Custom Search
|
![]() ![]() |
![]() |
![]() 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! -------------------- |
![]() Post#2 | |
![]() Posts: 1,023 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. |
![]()
Custom Search
|
![]() | Search Top Lo-Fi | 11th December 2019 - 12:09 AM |