PDA

View Full Version : Copy text from Word and paste into Excel VBA



dkelb1970
07-22-2011, 08:42 PM
I am a newbie to VBA........
I have a word document that is composed of many pages with text. I
want to take the text from page 1 after "Objective" and paste it into
A1, take the text after "Date" into B1, etc. Then on page 2 copy the
text after "Objective" and past it into A2, take the text after "Date"
into B2, etc. Do this until the end of the Word Document. Each page
follows the same format.
Thanks in advance for some VBA code for Excel that can save me tons of
time!

GTO
07-22-2011, 09:43 PM
I would suggest creating a Word doc with some fake data that replicates your current document's layout. Also an Excel wb that shows what the extracted/imported data is to end up like.

Zip both files and you can attach them by clicking the <Go Advanced> button, then the <Manage Attachments> button.

dkelb1970
07-23-2011, 07:44 PM
See attached. Thanks so much!