View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mabond mabond is offline
external usenet poster
 
Posts: 14
Default 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