Office 365 Excel - visual basic run time error '438'

Question

brought and installed MS Office 365 on home pc and trying to get Visual basic code to work

however, when running the below vba code i'm getting a runtime error '438' around the navigation to the website

Sub testie()

Dim ie As Object

Dim objCollection As Object

Dim i As Integer

Set ie = CreateObject("InternetExplorer.Application")

ie.Visible = True

ie.navigate = "http//www.google.co.uk"

End Sub

Clicking on debug highlights the ie.navigate line

The code appears to attempt to open the ie window but doesn't seem to like/understand the navigate command

Can you advise?

Answer 1

Hello,

I am an independent advisor, and I am trying to help other users in Community with my experience in Microsoft products.

When you are trying to use a method/property that does not belong to the object. For instance, if you have a Workbook object and try to access the Range property, it will give you the 438 error since the Range property belongs to the Sheets object.

Try without http//.

Do let me know if you require any further help on this. Will be glad to help you.

Thank you

Answer 2

Niall_T,

Try this:

ie.Navigate "www.google.co.uk"

without the equal sign and without http.

Jan

Answer 3

Many thanks Jan

Answer 4

Many thanks AvinashThakur2