-
Hi all,
I'm using the shell command to open pdf files in an external pdf viewer. I'm piecing the path of the pdf to open together with different variables and the "&" operator. When the path is pieced together, it's combined into a string, and that is used as the path for the Shell command.
EX:
ShowSpec = Shell(AcroPath & " " & WorkPath & "\PDF\" & txtBrand & "\" & txtSpecSheet.Text & ".pdf", 3)
This all works fine until I get to a folder in the path with spaces in it. When this occurs, Acrobat opens, but tells me that the file and path do not exist. This doesn't occur unless there are spaces in the folders in the path.
Is there something about the Shell command that doesn't allow spaces in the path names? That can't be right. How do I fix this? This is my last hurdle with this app, and I would really appreciate your help!
-
<?>
'replace function in VB6
'find an instance and replace it with another
Private Sub Form_Load()
string1 = "my name is somewhere to be found!"
MsgBox string1
string2 = Replace(string1, " ", "")
'String1 is now "mynameissomewheretobefound!"
MsgBox string2
End Sub
-
You're the stuff! Thanks a million!
