View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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