I'm new to this VBA thing, doing OK, but I'm getting lost here.
I'm working on a project that will be distributed to "newbies" to put it
nicely.
I know they will probably move the excel file around from it's intended
location.
In the application it creates a new version of itself for each new week.
I want to guarantee that new version is created in the My
Documents/Inventory folder.

I tried using CurDir to find out the current directory, it returns My
Documents every time, unless I manually do a File/Save As & then it reports
the proper My Documents/Inventory.

I just need to check the current directory, see if it's the My Doc/Inv & if
not, save it there, possibly creating the directory if they screwed it up!

& to add to the fun, this will be running on W98/2000/XP

Thanks!
--
Lee

www.raising-cain.com