I have a small tool that I use in my company to control our stock
level, recently we have expanded to encompass a further 2 buildings and
my project has started to go a bit crazy. it doesn't find the
directories of the various workbook required excetera. my question is
is there a code whereby I can through VBA rename or add or delete
obsolete directories? Please help me I am nearing the month-end and my
stock levels are a huge ???? thank you

Alan,
Look into RmDir, MkDir, Kill, Name.

Name does not appear listed in Help or the object browser, but its syntax
is:
Name OldDir As NewDir

Note:
A user's permissions may come into play
You have to Kill all files before you can RmDir
You cannot Name a directory if one of its files is open.

Hope that helps.

NickHK

"alanford" wrote in message
oups.com...
I have a small tool that I use in my company to control our stock
level, recently we have expanded to encompass a further 2 buildings and
my project has started to go a bit crazy. it doesn't find the
directories of the various workbook required excetera. my question is
is there a code whereby I can through VBA rename or add or delete
obsolete directories? Please help me I am nearing the month-end and my
stock levels are a huge ???? thank you

Thank you I will try, though I am not that familiar with these codes. I
may need to ask for your help again. Thanks for now. Alan