Thanks JLGWhiz.......
I obtain the CurrFilePath from "ActiveWorkbook.Path" and then save my
created file to (CurrFilePath & "\RequiredSubDir\" &
CreatedFileName). As far as I can work out, that should satisfy the
detailed input that you describe. Any other suggestions?
Cheers
Dave