Shell function problem (MS Access)
Hi
Trying to do this within Excel VBA but having a problem with the following
shell command. The command line switch can't open the named file.
Dim retVal
retVal = Shell("C:\Program Files\Microsoft Office\Office\MSACCESS.EXE S:\My
Folder\MyFile.mdb", 1)
The problem stems, I assume, from the space in the pathname (something over
which I have no control)
Is there a known solution to this issue or is there a more correct way to
type the pathname and filename to overcome the problem. i've tried several
combinations of parentheses with no luck
Any help appreciated
Michael Bond
|