Excel and DOS batch files

[Demented_Emu]

Hi All,
Head hurts with VB stuff so I thought I would ask all you nice bods
Is it possible using VB to add a DOS batch file into an Excel macro? Basically am trying to make job easier to spend more time surfin net

Any help muchly appreciated

Emu

[opus]

Did you try to "shell" it?

[Demented_Emu]

no as we can't work out? If i can find out will a shell do it?

[markf]

Here is an example of Shell in a Sub-procedure named ShellFromMe(), which should run C:\Autoexec.bat when you include the following line:

Call ShellFromMe


Public Sub ShellFromMe()
On Error Goto ErrorHandlerShell ' trap Shell errors
Shell "C:\Autoexec.bat", vbNormalFocus
Exit Sub ' immediately exits this Sub procedure

ErrorHandlerShell:
Msg = "Unable to run Autoexec.bat, the Batch file."
MsgBox Msg, vbExclamation + vbOKOnly, Me.Name
Resume Next ' resume at the next statement (Exit Sub)
End Sub


It is possible for your network administrator to prevent Shell running MS-DOS Batch script.