I have a couple of questions. I have a form that I need to MOVE files from one directory to another. I know how to move single files, the code I have now is:

Private Sub Command1_Click()
Dim FileSystemObject As Object
Set FileSystemObject = CreateObject("Scripting.FileSystemObject")
FileSystemObject.MoveFile "o:\GIS\Unmappped\259G.dwg", "d:\NewWorkOrder\259G.dwg"
End Sub

However I will not know the names of the files to be moved, so I need to move the contents of the directory to the other diretory. I can't copy because the o:\ directory has to be emptied.

Also I have the code in a Command button for this example but I need to know how to make this run "unseen"

Thanks for any help,

JO