Error 5 on Shell Command
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
|