Execute DOS commands in VBA code

[Guest]

Is there a simple VBA command similar to xp_cmdshell for T-SQL that will
allow me to execute a DOS command (e.g. MOVE, etc.) through VBA code - a
command that works for DOS like RunSQL works for SQL?

Thanks for your help ...

Bill Morgan

 

[Alex Dybenko]

Hi,
you can use Shell() function

 

[Douglas J Steele]

As Alex points out, the Shell command lets you run external commands.

However, if you're trying to move files from one location to another, the
VBA Name statement lets you move a file from one folder to another.

 

[Guest]

Got it. Thanks, Alex ...

Hi,
you can use Shell() function

 

[Guest]

Thanks, Doug. I am in the looking into both Shell() and Name statement.