Running VBS script through VBA

[smichael]

I have a script in VBS that I would like to run through a button on Excel. Is there a simple way to access this script, or will I have to convert everything into vba format?

 

[Kenneth Hobson]

You can use Shell() to run the vbs.

 

[smichael]

say my file path is C:\Data\PartUseEmail.txt how would i do this?

 

[Kenneth Hobson]

A TXT file is not a VBS file. You can search for solutions on this forum. Type a command in the VBE and with the cursor in the word or near it, press F1 for help.

Sub test()
  Shell "C:\Data\PartUseEmail.vbs", vbHide
End Sub