Using Shell cmd /c

[marksnow]

Hi

I have some code in my DB that opens up a file using the following code:

'Opens the file.
stAppName = "cmd /c " & Chr(34) & fileName & Chr(34)
Call Shell(stAppName, vbHide)

Now the above works perfectly well when opening a file on my C:\ drive even if there are spaces in the directory names. However as soon as I change it to a network drive it has issues with the spaces in the directory names.

I think our server is running linux could this be the issue?

Any help would be appreciated.

Mark

 

[Crowley16]

it could be...

try putting literal character marks before the spaces, off the top of my head, for unix, it's something like:
\\dir\fname/ moreName

but do check that...

--------------------
Procrastinate Now!