Does anyone know how I can run a vbs script from a macro. I have been cobbling one toghether but cannot get it to work.
Dim objShell as Object
Set objShell = _
objShell.Exec (“cscript \amhs-ediis1\Ad Hoc Reports\Frank\ED Scheduled Reports\SendmailEDISv2.vbs”)