Shelling Word Documents

[Auld Nick II]

I'm trying to shell a word document from Access VBA, passing the path to the document in the command line. My problem is that some of the paths that are passed have spaces in them, and when you use command line parameters in this way it interprets a space as the end of the command line and thus fails to open the document. I've tried writing code to URLEncode it myself, but it doesn't like this. I've tried shelling Internet Explorer with the path in the command line, but this gives me file not found. Does anyone know of any other ways that I can open a document programmatically from Access VBA?

[Buzby]

Just put double quotes around it

Shell "winword.exe "+chr(34)+"this is a document.doc"+chr(34)


The chr(34) puts a double quote " around the name of the document.

[Mc Brain]

Try this:

Private Declare Function ShellExecute Lib "shell32.dll" Alias _
  "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
   ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory _
   As String, ByVal nShowCmd As Long) As Long
Private Const SW_SHOWNORMAL = 1
 
 
'To open the file...
ShellExecute 0&, vbNullString, "C:\myDoc.doc", _
   vbNullString, "C:\", SW_SHOWNORMAL