Execute VBScript from VBA?

[joe.afusco]

Anyone know the syntax to execute a script from VBA?

 

[hiker95]

joe.afusco,


If you are asking to run a macro from another macro, then:


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Option Explicit
Sub Execute_VBScript_from_VBA()
' hiker95, 03/02/2012
' http://www.mrexcel.com/forum/showthread.php?t=618285
Call TestA
Call TestB
End Sub


Sub TestA()
MsgBox "Running/executing macro 'TestA' !"
End Sub


Sub TestB()
MsgBox "Running/executing macro 'TestB' !"
End Sub

Then run the Execute_VBScript_from_VBA macro:

 

[Firefly2012]

If you literally mean running a VBS script then the following worked for me:

'in Excel module
Sub Test()
Shell "Explorer.exe ""C:\Some Folder\MyVBSFile.vbs""",1
End Sub

 

[joe.afusco]

Yes a vbs script is what I meant. Thanks! Secondary question that might rule out doing this through a script... I assume it is possible, but do the same fso methods in vbs work in vba? Renaming, deleting, moving files, etc.

 

[hrlngrv]

Why explorer rather than wscript or cscript? If the reason is using the default association, more robust to use

Shell Environ("COMSPEC") & " /c start """" ""script path here""", 1

 

[hrlngrv]

You can access most Windows Scripting Host and VBScript objects from VBA. Add references to Microsoft Scripting Runtime and Microsoft VBScript Regular Expressions 5.5 to the VB project. There are many examples of accessing RegExp, Dinctionary and FileSystemObject objects on the web.

 

[Firefly2012]

Why explorer rather than wscript or cscript? If the reason is using the default association, more robust to use

Shell Environ("COMSPEC") & " /c start """" ""script path here""", 1

A mixture of lack of knowledge as regards the alternatives and also laziness since explorer worked!
Your post has gone some way to resolving the first issue but I'm probably stuck with the second

 

[joe.afusco]

So, this is going to sound pretty stupid. I've stored my script directory / file name in a string. How can I execute it from there? Can't seem to get it to work with the following suggestion:

Shell Environ("COMSPEC") & " /c start """" ""script path here""", 1

 

[joe.afusco]

Nevermind. Trial and error figured it out.

Thanks for all the help!