I have a code that successfully calls up a VBS file over the C drive, but i can't get it to work for a file that isn't saved locally. Is there a way to alter my code for this to open a file saved on a separate computer over a server?
here's my code:
Thanks for the help!
here's my code:
Code:
Sub SendEmail()
'
' SendEmail Macro
'
'Opens VBS file to send e-mail of copy
Dim filespe As String
filespe = "cmd.exe /c [URL="file://\\ABE2-MP\Data\PartUseEmail.vbs"]\\ABE2-MP\Data\PartUseEmail.vbs[/URL]"
x = Shell(filespe, 1)
Application.WindowState = xlNormal
Application.DisplayAlerts = True
'
End Sub
Thanks for the help!