Passing a PARM to 'Shell' that has embeded blanks

[koz]

I am trying to shell to Microsoft Word passing the Path & Document name as one string. Each one may or may not contain embeded blanks. These are documents related to items in an Access database and may reside anywhere.

Is there a better way than using 'Shell'? I like the 'Shell' approach because it minimizes code in my program.

 

[JohnYingling]

This worked for me.
Shell """C:\Program Files\Accessories\Wordpad.exe"" """ & strFilename & """", vbNormalFocus
i.e in Run it would be
"C:\Program Files\Accessories\Wordpad.exe" "parms"

http://www.VBCompare.com

http://www.VBSortGen.com

 

[koz]

Thanks for your help John. Everything is working now.