I would suggest that in your code, you start Excel and open the workbook right at the start, rather than doing that each time a Normal style paragraph is encountered.

Doug,

Thank you for that suggestion.

The problem with having it where it was (other than being untidy and redundant) was that I re-initialised the xlRow variable to 2 every time, so in fact I was simply rewriting everything to the same row, instead of incrementing the counter and writing to the next row.

One of those mistakes when you're overtired and been looking at something too long!


Cheers,
Irene