one way

fPath = Application.ActiveWorkbook.Path

--


Gary


"GeneWan" wrote in message
...
eg. my code prompted user to choose the file(s) to be opened within the same
path. How can I save the path so that I could use it later on?

purpose is so that I can create a file in the same path afterwards..