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.