VBA+Select Webpage Drop Down

[asleepdirka]

Hello all,

I am trying to use VBA from excel to select an item from a drop down list on a webpage. There are two drop down lists on the page, and it is in the first list. I need to select the second option value below(1234variable-name.xls), which is the first selectable item in the list. This name is always changing each time I visit the page, so I need select it as the second item in the list, rather than by name. I've tried many different codes, but not working yet.


__________________Here is the HTML webpage code_____________________________

'

<div class= "Content">

<select name="ct100 style="width:220px; ">

<option value=” (Select a report) ”> (Select a report) </option>


<option value=”/MyCompanyDept/CompanyFile/MyCompanyDept/Reports/1234variable-name.xls” title=”4/10/2013 - My Company - ReportName”>4/10/2013 - My Company - Report Name</option>


<option value=”/MyCompanyDept/CompanyFile/MyCompanyDept/Reports/do not need this one.xls” title=”4/10/2013 - My Company – ReportName2”>4/10/2013 - My Company - Report Name2</option>

</select> <input type="button" id="btnGo" name="btnGo" value="Go" class="SmallButton"

onclick="viewReport()" />

</div>

'


THANKS FOR ANY HELP!

 

[SirJB7]

This topic is the same as last question of this, just a few days (6) of difference:

http://chandoo.org/forums/topic/vba-select-nth-item-from-web-page-drop-down-select-by-its-position-in-list


What you're doing "is called cross-posting and is generally frowned upon in the Blogosphere as it causes people to potentially waste our time when a question is already answered. You should also check and respond to posts and let posters know if they are heading in the write direction or not." Hui's dixit, SIC. And I agree 101%.


If you'd have read the main green sticky post at this forums main page...

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting

...you should have noticed this points:


"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."


"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."


"Cross Posting, generally it is considered poor practice to cross post, that is to post the same question on several forums in the hope of getting a response quicker."


"If you do cross post, please put that in your post."


"Also if you have cross posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting there time on your answered question."


"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."


"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."

 

[asleepdirka]

My apologies SirJB!

I have read the forum rules, but I thought my post was buried and never to see the light of day again. First time on one of these forums. Will use better etiquette in the future.

 

[SirJB7]

Hi, asleepdirka!


No problem, I know that's frustrating don't receiving answers (I too feel/suffer that with my posts sometimes), but I insist on what I wrote you in the crossposted topic:

http://chandoo.org/forums/topic/vba-select-nth-item-from-web-page-drop-down-select-by-its-position-in-list#post-95561

"Regarding your unanswered question in this topic, maybe the information you provided (3 lines instead of a workbook and the link to a webpage) have been insufficient to people who might have read this -because I can assure that many people read all the topics, including this, including myself-. If I suppose correctly they hadn't the elements to fully understand your issue and that's why you didn't receive any answer."


Regards!