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
|