Open a picture externally

[jesusoneez]

I have the following code;

Private Sub cmdProof_Click()
    Dim MyFilePath As String
    
    MyFilePath = "N:\Pictures\" & Me.txtBanID.Value & ".jpg"
    MsgBox MyFilePath
    Call Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE", MyFilePath, "", vbMaximizedFocus)
End Sub

I know the mistake is in the Call Shell line at the point of MyFilePath, but I don't know how to fix it.

EDIT: The error being wrong property argument.

Thanks for any help.

 

[Dennisk]

I think you need to concatenate the path/Filename like this
("C:\Program Files\Internet Explorer\IEXPLORE.EXE " & myFilePath

 

[jesusoneez]

Nope, I had tried that before the code I posted above.

Changing it to this;

Call Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE" & MyFilePath, "", vbMaximizedFocus)

produces the same error;

Wrong number of arguments or invalid property assignment.

 

[PeterF]

The wrong number of arguments is because windows evaluates
C:\Program Files\Internet Explorer\IEXPLORE.EXE as 3 paramaters because of the spaces. add aditional single quotes around the path and filename to prevent this.

"'C:\Program Files\Internet Explorer\IEXPLORE.EXE" & "' '" & MyFilePath & "'"

 

[jesusoneez]

Thanks PeterF. That's great to know for future reference but I just discovered Application.FollowHyperlink and used that instead.

Thanks again.