Moving a folder with VBA 1

[rocknrisk]

Hi all,

Is there a way to move a folder (or file) on my system using VBA (using the file system object).

Help will be much appreciated.

Thanks in advance.

 

[Loomah]

Hi
Have a look at this thread (thread707-268381) and use move instead of copy for the batch file solution. I can't confirm it, as I don't have the necessary help files, but I'm sure that MoveFolder is available in the FileSystemObject.
;-)

 

[Loomah]

Might have been a bit hastey here as it doesn't work the way I was expecting.

:~/

 

[Loomah]

I'm feeling better now!!

Sub test()
Dim oFSO As Object
Set oFSO = CreateObject("Scripting.FileSystemObject&quot
oFSO.movefolder "c:\test", "c:\me\"
Set oFSO = Nothing
End Sub

I created the 2 folders "test" & "me" and this code moves "test" into "me" successfully. The problem I had before was omitting the "\" at the end of the destination folder.
;-)

 

[rocknrisk]

Hi Loomah,

Many thanks. "Finish what you started"

 

[xlbo]

If Loomah's solution worked, you should give it a star - click on the "Click here to mark this as a helpful or expert post" - it's the only recognition people get for helping out
G