Tim,Thank you, it works fine now. Phew I'd been playing around with it for quite a while but couldn't get the 'angle' right. I had the variable working as a 'save as copy' of the whole file, but just getting it to excel format held me back.
Thanks again.
Lee Mills
