Thanks



I followed your link but I didnt see the answer on there. Maybe I wasnt looking in the right place.

Is there a simple was that (from the Word VBA module) of...

- Counting the number of rows used on a particular worksheet
- Returning a value from a particular cell

I'm sure I could work out what I'm trying to do from that

Sure, you could simplify the code I posted - by deleting the error-checking, for example - but then you'd risk it falling over. A considerable portion of the code goes into checking whether Excel is already running and whether the workbook exists and whether someone else has it open (which might mean the data are changing).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]