Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Abstracting text from WORD into Excel
Greetings !
I have some (OK, several hundred....) Word documents most of which contain the words "Contract" followed by the Contract number, "Date" followed by the contract date, and "Value" followed by its value. Curiously, I wish to search all the WORD documents in the various folders, and, where they exist, extract those three values and paste them into an Excel spreadsheet, with also the path and name of the files from which they came. Fairly straightforward requirement - but I just don't know where or how to even START ! ..txt files I could do easily..... Any help would be much appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Abstracting text from WORD into Excel
We would turn on the macro recorder in Excel;
with A1 of sheet 1 highlighted, click Data/Import External Data/Import Data; select text file, delimited with space; the whole of the word document is now in Excel with one word in each cell; now Edit/Find "Contract" the next cell is the contract number you want to copy to say sheet 2; repeat find with "Date" and "Value"; copy text file fullname property also; You have macro for the first file. Look up archive to loop through all folders; stitch them together, you are done. "Robin Clay" wrote in message ... Greetings ! I have some (OK, several hundred....) Word documents most of which contain the words "Contract" followed by the Contract number, "Date" followed by the contract date, and "Value" followed by its value. Curiously, I wish to search all the WORD documents in the various folders, and, where they exist, extract those three values and paste them into an Excel spreadsheet, with also the path and name of the files from which they came. Fairly straightforward requirement - but I just don't know where or how to even START ! .txt files I could do easily..... Any help would be much appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Abstracting text from WORD into Excel
"PY & Associates" wrote:
We would turn on the macro recorder in Excel;..... Thank you very much indeed ! I've not tried it yet, but that looks EXACTLY what I sought ! I'm very grateful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Why would Excel stop auto text for one word only | Excel Discussion (Misc queries) | |||
How do I get text effects in excel like those available in word | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I copy a Word text file into Excel in a way that each char. | Excel Discussion (Misc queries) |