Thanks Norrie

No I can't post what I've tried because I dumped it all in frustration. had tried many permutations of code off the net but it seems noone wants to do this specific task as i couldn't get a hit with it. One of them had Application.GetOpenFilename in there somewhere.

Will give your code a run shortly.

cheers
Kranky