PDA

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



dkelb1970
07-22-2011, 08:41 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!