Thanks for your solution; will try it out!
; )

"Bob Flanagan" wrote:

If any of the workbooks you have open are from this directory, then if you
activate one of them, activeworkbook.path will return the path to the
directory.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Jac" wrote in message
...
Hi,

I would like to save some files in a particular folder, for example
(Ven_Folder) in my computer system; but this folder may be transffered to
another directory time after time. So instead of using the absolute path
to
fix the file saving location; I would pretty much wish that there could
have
a way the macro can help to lookup for the folder path before those
mentioned
files are saved.

I have tried out the Dir statement but it can only work in the 1st loop in
looping control structure. Thus, anyone can help in this matter.......????

Thanking in advanced.