Log in

View Full Version : VBA and HTML automation



Kamson
04-26-2011, 09:59 AM
Hello,
Thanks in advance for your assistance.
I am able to write to an html page via vba..i.e. populating text field.
The problem that I have is with HTML's dropdown. Basically the VBA code is not populating the dropdown, below is the code that I used :

Set MyObj = IE.Document.getElementsByTagName("Select")
MyObj.Item(1).Value = "Something"

Do While IE.Busy Or IE.ReadyState <> READYSTATE_COMPLETE
DoEvents
Loop

Any suggestion to fix the problem?
Thanks

dicepackage
05-02-2011, 06:56 AM
Could you give us the URL for the site you are working with?

Kamson
05-03-2011, 08:17 AM
Thanks for your reply, I found the solution..

Bob Phillips
05-03-2011, 09:44 AM
Care to share it?