It's not clear what you're trying to do! It seems that you have a
roaming file that may be used on various machines, but that you want to
save it to a particular machine regardless of where it's run from.

ThisWorkbook.Path is the location of the file running the code.

You could open a folder browser dialog so you can select the path to
save to. This obviates having to hard code path/drive letters and
folders, and would simplify coding as well as give you some
flexibility.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion