VBA can't find path opening PDF file...error...Need HELP!!!

[sclinkenbeard]

This is the script that won't find any of my pdf files...error states file can't be found and I know the path is correct...If anyone can help...Please. I have tried many pdf docs with the same results. What am I doing wrong in my script?

Sub test()
Dim RetVal

RetVal = Shell("C:\Program Files\Adobe\Reader 8.0\Reader\AcroRd32.exe C:\Documents and Settings\Owner\My Documents\dwdm.pdf, 1")
End Sub

[Sick0Fant]

This is the script that won't find any of my pdf files...error states file can't be found and I know the path is correct...If anyone can help...Please. I have tried many pdf docs with the same results. What am I doing wrong in my script?

Sub test()
Dim RetVal

RetVal = Shell("C:\Program Files\Adobe\Reader 8.0\Reader\AcroRd32.exe C:\Documents and Settings\Owner\My Documents\dwdm.pdf, 1")
End Sub

My best guess is that it's interpretting C:\Documents and Settings\Owner\My Documents\dwdm.pdf as 3 arguments because of the spaces. Try putting the path in quotes.

[sclinkenbeard]

Quotes generates a compile error.

[Sick0Fant]

Quotes generates a compile error.

You have to escape them, of course! Use "" to represent "

[sclinkenbeard]

Still comes up file can't be found. Thanks anyway. Not sure the issue but it appears no one else on this help page does either.