Using VBA to extract data from headers? (1 Viewer)

Hi all,

I'm very new to VBA in Word so you may have to bear with me a little!

I'm currently trying to automate the transfer of data from a reporting sheet/grid in Word to a database in Excel (I will redesign the input in time, but for now, I need to import existing sheets).

I've managed to get Excel to take almost all of the information ok, but I'm stumped when it comes to this part...

The report is formed of a series of 'nodes', each node is its own grid with a header at the beginning of the section containing information in a small table. Each node is separated by a 'next page' break and the sections are un-linked. Within this small table in each node's header, among other things is a list of drawings that were used to write that node and it is these drawing numbers that I need to extract and somehow peg to entries for each node in the database.

My thoughts were to try to extract the drawing numbers to successive rows on a blank sheet in my Excel document, I can then use this to import into the database using another VBA routine...

Could this be done? I'm a bit lost when it comes to Word macros!

Thanks,

Nick