Executing shell commands in VBA

[Abhishek]

Hi,
Does anybody know how to execute shell commands such as "copy" in VBA.

Thanks,
Abhishek.

 

[Vince]

Simplest method is:

Dim a As String
a = "c:\windows\system32\xcopy c:\wf.exe c:\aa.exe "
Shell (a)

 

[Vince]

BTW, FWIW, I would rather use the filesystemobject to do file manipulation
like copying, deleting and renaming files than shell system commands.

 

[Michael Bednarek]

Does anybody know how to execute shell commands such as "copy" in VBA.

By invoking your shell with the appropriate arguments.

Assuming that it's the command COPY of CMD.EXE you desire to execute,
the command might look like:
Shell ("cmd /c copy source.dat target.dat")
For details see CMD /? from a CMD prompt.

However, as Vince suggested, methods native to VBA are probably
preferrable.