weejas
Thank you again. I think I can use the latest code to do what I want.
As I will only ever export one file at a time i will set up a cell on the front page where people can enter the file name and run the import macro to refrence that. This is only the 2nd or 3rd time I have done anything more than just record a macro. It feels good.
John