M
Mark Stephens
Hi,
I am attempting to use the DOS Shell command xmove to move all files from one folder to another. I t should be pretty straightforward but it isn't working and I am at a bit of a loss to know why?
Here is the sub:
Public Sub MoveFile(sSourceFile As String, sDestFile As String)
Shell "cmd /c xmove /y " & sSourceFile & " " & sDestFile
End Sub
Here are the inputs:
sSourcePath = ActiveWorkbook.Path & "\Outputs\*.*"
sDestinationPath = "C:\Users\User\Dropbox (Simulytics)\SOFTWARE\data preparation\c DASHBOARD DATABASE PRODUCTION\Inputs"
and here is the call:
Call MoveFile(sSourcePath, sDestinationPath)
Any ideas?
Kind regards, Mark
I am attempting to use the DOS Shell command xmove to move all files from one folder to another. I t should be pretty straightforward but it isn't working and I am at a bit of a loss to know why?
Here is the sub:
Public Sub MoveFile(sSourceFile As String, sDestFile As String)
Shell "cmd /c xmove /y " & sSourceFile & " " & sDestFile
End Sub
Here are the inputs:
sSourcePath = ActiveWorkbook.Path & "\Outputs\*.*"
sDestinationPath = "C:\Users\User\Dropbox (Simulytics)\SOFTWARE\data preparation\c DASHBOARD DATABASE PRODUCTION\Inputs"
and here is the call:
Call MoveFile(sSourcePath, sDestinationPath)
Any ideas?
Kind regards, Mark