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.
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...
The website I am working on is a company intranet page, which contains highly sensitive information and anything exported would be blocked by our web marshall; sorry I can't provide more detailed information. There are only two drop down lists on the page and when you click on my item you get a...
Unfortunately not able to try your suggestion Narayan. At this point, I would be happy just to get the drop down item selected.
Thanks for looking at it though!
I may not be able to do that due to company restrictions, but I'll try. Either way, in order to access the excel file, I have to select the 2nd item in the list for the excel message box to appear; "Open or Save File". I thought there may be a way to call the item by it's position in the list...
I should add that the following code exits before and after the option values post above:
<div class= "Content">
<select name="ct100 style="width:220px; ">
'Drop Down Options are listed here...
</select> <input type="button" id="btnGo" name="btnGo"...
Hello,
Any assistance with the following VBA code is greatly appreciated!
Task:
1. I use an excel macro to open internet explorer and Log In to my intranet company website (already done), I need to select the second item in the first, of 2, drop down boxes. The name in the dropdown list...
Thank you Narayan!!!
The line I had to change in the VBA was;
Set SignInButton = LoginForm.elements("ctl00$MainContent$containerMain$loginMain$btnLogin")
Now I just need to figure out how to select an item from a dropdown menu which prompts to open excel file, open and save it. I'm sure...
Thank you for your speedy reply NARAYANK991. I won't be able to try your resolution until tomorrow, but I will let you know how it turned out, good or bad.
Your help and time is very much appreciated!
Thank you,
Hello all,
I have a challenging VBA macro that attempts to Login to an intranet website. Using the code below (credit to a previous poster), I am able to navigate to the login webpage and populate the Username and Password fields, however, I cannot get the Submit portion to function. I have...