It might be better to let
VB select the user's command processor rather than
hard coding it (not all past versions of Windows used cmd.exe)...
Shell Environ("COMSPEC") & " " & strDirectoryList & ".bat", vbHide
--
Rick (MVP - Excel)
"joel" wrote in message
...
the shell doesn't understand command line instructions or bat files. you
have to use cnd.exe to execute the bat files.
Shell ("c:\windows\cmd.exe " & strDirectoryList & ".bat"), vbHide '',
vbMinimizedNoFocus
"ExcelMonkey" wrote:
I am getting an "Error 5 Invalid procedure call or argument" on the
following:
lStr_Dir = ThisWorkbook.Path
strDirectoryList = lStr_Dir & "\Directory"
Shell (strDirectoryList & ".bat"), vbHide '', vbMinimizedNoFocus
?strDirectoryList
\\CGAS114\Username\My Documents\The Folder\ExcelVBA\Directory
Is this due to the spaces in the path?
Thanks
EM