Prev: Hide / Unload Form
Next: Hiding format tabs in Word 2007
From: John on 23 Mar 2010 08:35
BACKGROUND/CONTEXT

I am working from a very large word document, approximately 1000 pages
long. Each page has one 'article' on it.

I am currently doing something manually, which I would love to do
using a macro.

I am populating a table (which happens to be in an Excel spreadsheet)


One column is the Article number 'xxxxx'. One of the other columns is
a 'Topic' which is typically three alphanumeric characters (like AA1,
AD4, BB4 DO6 etc.)



PROBLEM/TASK

This is what i have to do

Step 1 - Jump to the page with the article number. Achieved by
pressing control-f and searching for '10022' or 'Article: 10022'.

Step 2 - I press the 'up' arrow key (about) four times to reach a line
called 'Topic: AB1'. I then copy 'AB1' to the clipboard and paste it
into an Excel spreadsheet.


This is obviously a complex task to automate, so any hints/tips would
be greatly appreciated.




Thanks for any hints/tips
From: Doug Robbins - Word MVP on 23 Mar 2010 17:15
Is it always Topic AB1 that you are wanting to copy? Is the Topic always on
the same page as the Article? Do you need to do it for multiple Articles
(which would be the only reason that I could see for bothering to automate
the task)? If so, from where will those Article Numbers be obtained? Are
they already in the Spreadsheet? If so, is it that you have a spreadsheet
with a column of Article Numbers and other columns headed with the Topic
number and you want to populate the cells in the rows for each article with
each of the topics?

In other words, we really need to know exactly what it is that you want to
do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"John" <helpme.code(a)yahoo.com> wrote in message
news:ef8da968-cbf5-467f-b9e0-1ef081e7f923(a)t41g2000yqt.googlegroups.com...
> BACKGROUND/CONTEXT
>
> I am working from a very large word document, approximately 1000 pages
> long. Each page has one 'article' on it.
>
> I am currently doing something manually, which I would love to do
> using a macro.
>
> I am populating a table (which happens to be in an Excel spreadsheet)
>
>
> One column is the Article number 'xxxxx'. One of the other columns is
> a 'Topic' which is typically three alphanumeric characters (like AA1,
> AD4, BB4 DO6 etc.)
>
>
>
> PROBLEM/TASK
>
> This is what i have to do
>
> Step 1 - Jump to the page with the article number. Achieved by
> pressing control-f and searching for '10022' or 'Article: 10022'.
>
> Step 2 - I press the 'up' arrow key (about) four times to reach a line
> called 'Topic: AB1'. I then copy 'AB1' to the clipboard and paste it
> into an Excel spreadsheet.
>
>
> This is obviously a complex task to automate, so any hints/tips would
> be greatly appreciated.
>
>
>
>
> Thanks for any hints/tips

 | 
Pages: 1
Prev: Hide / Unload Form
Next: Hiding format tabs in Word 2007