Open Address Field in Web Browser

[MatthewGrace]

I have a button that opens a web page based on a field. It works just fine:

Private Sub cmdPreview_Click()
    'Launch IE
    Dim ie As Object
    Set ie = CreateObject("InternetExplorer.Application")
    ie.Visible = True
    ie.navigate Me.subEmailAssets.Form![Address]
    Set ie = Nothing
End Sub

But it comes up short in one situation: If that [Address] field happens to be an .mp4 it does NOT open the browser (IE), but instead prompts the user to download the .mp4. Is there any way to suppress my "ie" objects desire to automatically open this window?


While we're at it, you can see I'm doing this all using InternetExplorer.Application class. Is there something more recent for Microsoft Edge? Or any other class - so long as its object model is thoroughly documented with code samples so I can figure out how to use it?



Thank you.

[rpeare]

have you tried the followhyperlink method rather than creating an internet explorer object?

swebpath = "http://techslides.com/demos/sample-videos/small.mp4"
Application.FollowHyperlink swebpath