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]