VBA Code for to Submit Button

Hi:

I am a newbie in VBA. I have a list of bonds whose price I want to update everyday. So, I thought I should write a macro for it. I am using this site to get the latest price data: http://finra-markets.morningstar.com...&symbol=VMC.GP

I have the CUSIP number of the bonds and I want to use this as the search field. The website has assigned some internal ticker to each bond that shows up in the address bar, See the ticker and symbol in address above. So I cannot use a direct method to get the price data. However, the site also allows users to search for bonds by CUSIP number. When you go on the page, if you put the CUSIP number instead of "Lookup Symbol". You will get the result. For instance if you put "90131HAA3" in the field of Lookup you will get the correct result.

So, I have tried to write a code that opens the page and put the CUSIP code in the search field. However, I am unable to click the "GO" button. It is not working. I am getting no errors.

Please help.

Please Login or Register  to view this content.

You could try .submit instead of .click.

Been a while since I've done any IE automation, so if that doesn't work I'll have to declare myself 'out'.

Tried but got an error. "Object does not support this property"