Passing Multiple Command Lines 1

[MikeC14081972]

I'm trying to pass multiple command lines from Access using Shell

I can change the directory using the following

strShell = "cd /d H:\{Full FilePath}

This then leaces the command line window open with the following

{Full FilePath}>

My question is: How can I now pass another command to the open window to execute a batch file with parameters.

I have tried

strShell = "H:\{Full FilePath}\batch {parameters}"

but this doesn't work due to spaces in the filepath.

Thanks

 

[MikeC14081972]

If anyone is interested the answer is

strShell = "H:\{FullPath} && batch {parameters}"
Shell(strShell)

the

&&

acts as a command seperator.

 

[kjv1611]

Thanks for posting the answer when you found it. And that does sound interesting, hadn't thought of using command lines from within Access. That might help with a few things, if I ever get to those.

--

"If to err is human, then I must be some kind of human!" -Me