Spaces not excepted in Shell Command

[simmons84]

I am using the Shell command to open Wordpad and then an .RTF file. It appears Shell commands don't like spaces in the file path. I know you have to use """" to get around it, but can someone show me how?

Call Shell("C:\Program Files\Windows NT\Accessories\Wordpad.exe N:\Documents\Files\My Grinders\Grinder 1 Dress\1234.rtf", 1)

It won't recognize anything past "My" on My Grinders. I suppose the same thing would happen for Grinder 1 Dress.

Any suggestions? Thanks

 

[tweedle]

Try

Call Shell("C:\Program Files\Windows NT\Accessories\Wordpad.exe " & """N:\Documents\Files\My Grinders\Grinder 1 Dress\1234.rtf""", 1)

note the space after exe

 

[SydneyGeek]

This thread has been moved to the General Excel Discussion forum as it is not Excel-related.

Denis