Renaming adding and deleting directory
 

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

Renaming adding and deleting directory
 

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

Renaming adding and deleting directory
 

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