PDA

View Full Version : Navigate to WebBrowser problem



stevespauldi
05-15-2013, 11:11 AM
Need help with macro statement:
Worksheets("TEAMS SET-UP SHEET").WebBrowser1.Navigate2 URL

And the URL = http://m.ghin.com/HLR.aspx?ghinno=6706315

(6706315 is the first number in a list of numbers that routine searches for on website)

In debug mode, when this statement executes, my program returns:
Run-time error ‘438’:
Object doesn’t support this property or method

This use to work properly, but something must have changed on my computer.
I’m using Excel 2003, Windows 7 Home Edition, and I normally browse using Google Chrome (but also have IE8).

Also, when I start my application now, I get message:
This application is about to initialize ActiveX controls that might be unsafe. If you trust the source of this document, select Yes and control will be initialized using your document settings.

(I did not use to get this message when program ran properly.)

This still does work properly on a friend of mine’s computer.

ANY SUGGESTIONS???

I appreciate any help.