M
mabond
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
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