Response.Redirect visual basic

1

I am new using macros, could you tell me if this is the right way to open a web page:

Sub Reporte()

Response.Redirect ("http://www.microsoft.com")

End Sub

I will get the following error:

  

Error 424 has occurred at runtime

     

Object required

    
asked by ARR 14.06.2018 в 18:47
source

1 answer

5

I hope to understand your question well, is it from a macro to open a web address in HTML? If so, then it could be done this way.

Create object, in this case Internet Explorer and specify the URL to navigate. It's a way, I hope it can help you.

Sub navegar()
    Dim ie As Object
    Set ie = CreateObject("Internetexplorer.Application")
    ie.Visible = True
    ie.Navigate "http://www.google.com"
End Sub
    
answered by 14.06.2018 / 19:11
source