Calling .bat file

[mikeymay]

I have a batch file saved as follows

\\Global.com\file\ResourcePlanningControl\shared\ResourcePlanningControl\FTE Control\Branch\Public Folder Access\Glide Paths\RevokePublicAccess - Glide Paths.bat

I would like to call and execute this file as part of a rountine.

A colleague has supplied the following code to do this

Call Shell(Environ$("COMSPEC") & " /c \\Global.com\file\ResourcePlanningControl\shared\ResourcePlanningControl\FTE Control\Branch\Public Folder Access\Glide Paths\RevokePublicAccess - Glide Paths.bat", vbNormalFocus)

but this doesn't seem to work.

Not sure how to correct this and is this the best way of doing this?


Thanks

 

[John_w]

There are spaces in the folder path and file name, so you need to surround the filespec with quotes, like this:

Call Shell(Environ$("COMSPEC") & " /c ""\\Global.com\file\ResourcePlanningControl\shared\ResourcePlanningControl\FTE Control\Branch\Public Folder Access\Glide Paths\RevokePublicAccess - Glide Paths.bat""", vbNormalFocus)