View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Moving Directories

This won't work across drives, but works in the same drive:

Sub AAA()
Name "c:\system\live\12345" As "c:\system\dead\12345"

End Sub


--
Regards,
Tom Ogilvy

"Robert Pollock" wrote in message
...
Hi, I would like to write a macro that would move a named
directory including the word and excel files inside it,
from one directory to another.

Example - move directory called 12345

source = c:\system\live\ and destination = c:\system\dead\
so the existing path would be c:\system\live\12345

The user would be prompted for the name of the directory
to be moved (in this case 12345) by an input box.

Thank you.
Robert Pollock.

PS : Would the directory move with it's contents from one
command, or would the contents have to be named in
variables ?