I have a Batch file that has this command called test.bat
copy %1 %2
Then on a form I have a button with this command:
Private Sub cmdBackBatch_Click()
On Error GoTo err_cmdBackBatch_Click
Dim strSource As String
Dim strDest As String
strSource = "C:\Documents and Settings\A\My Documents\Robby\Tracker\TrackerDev\FE-BE\ABCMngr97_be.mdb"
strDest = "C:\Documents and Settings\A\My Documents\Robby\Tracker\TrackerDev"
Shell "C:\Documents and Settings\A\My Documents\Robby\Tracker\TrackerDev\FE-BE\test.bat" & strSource & " " & strDest
Exit_cmdBackBatch_Click:
Exit Sub
err_cmdBackBatch_Click:
MsgBox err.Description
Resume Exit_cmdBackBatch_Click
End Sub
For some reason I am not able to pass the strSource and strDest variables to the %1 and %2 of the batch file command.
Does anyonw have some input on this?
Thanks.