I am trying to retrieve the "option" values and "inner text" from two dropdown lists on a website. Using the code below I can retrieve the data from the first list but the second dropdown is not populated until a value is selected in the first list.
Firstly, is it possible to specify a particular "select" element by using its "name" or "id" and if so how? Secondly, will I be able to populate the second list by looping through each of the values from the first list and retrieve the second list values each time?
I have been searching all day so far and cobbling together bits of code that I have found that do some but not all of the process I require.
Below is a small section of the results so far. The second dropdown list will give the models based on the value selected in the first dropdown.
inner text value Alfa Romeo 53 Aston Martin 69 Audi 16 Bentley 87 BMW 17 Chevrolet 77 Chrysler 54 Citroen 18 Dacia 92 Ferrari 95 Fiat 19 Ford 20 Honda 22
I am trying to write a macro that will allow me to add task to [url].... (task managing webpage) from data within excel. I could easily write a macro that emails the information to my toodledo email address, but this is not what I would like to do.ow to start the code utilizing Toodledo's API, which can be found here:
I am trying to prepare macro to navigate web page and click on some tasks to complete it. As this web link is not access-able from outside or remotely. I am trying to work on it in bits. I have came across with a first problem of clicking on one of the link of this web page, below is the web page html source code. I want to click on last link "Total Outstanding Tasks".
I am a Coach who will be using this data table to call pitches via a catcher's wristband. The band is obviously completed below; however, I need to create a separate sheet where the numbers correlate to the pitches that are being called. How it works: everything in the table(s) with a dash is a pitch i.e. 2-1, 1-3, 1-U, etc. The numbers on the columns and row are what is relayed to the catcher to call the corresponding pitch. For example, I would signal is 113 (first number = row second number = column). 113 is 4-1. I need a way/ formula to where I can see which numbers are to be relayed in for each pitch. It would possible look like 2-1: 101, 411, 422, 501, etc.
I have a number of files organised in a number of folders on Dropbox. I create a macro to enable me to be able to navigate to a particular folder and then get a list of all the files in that folder to be placed within certain cells on the spreadsheet I'm working with in Excel.
What I'm after is an easier way to get data combined without having to type it all out. If you look above I would like to have A-C actually as dropbox's or listbox's, something I can click, then drop down to the proper name and select it. Then on E I'd like a timestamp for when this action was done with the date and time as shown along with the reason. Then in F I'd like the Name fields combined so I just need to right-click on F and copy/paste into the other program I use.
Maybe one column can just be the names of everyone with a selection box and I click this stuff then when I am done it resets?
I have several cells with data validation's drop Box. Every data validation uses a range name as source (myColorList). Here goes the hard part: I need a new value inside the dropBox list, but The problem is that I can NOT modify the "myColorList" range.
-- Is there any way to build up the dropbox source using the range name and the new value? Something like
It's quite easy, I am trying to do a droplist (that's easy) but I want that drop list to take infos on 2 different columns and fill the 2 columns I want in the main sheet (see attachment)
On tab 'dealers' I have dealers name and account numbers. On tab 'Mileage' I have a cell call "NAME' and a cell call 'Accnt #/NB'. Here is what I want to do:
On sheet 'Mileage' I want to choose from a drop list a dealer name and I want Excel to populate the cell "Accnt#/NB" automatically by chosing the account number that is appropriate to the dealer choosen which is column 'B' in the dealers tab.
I am trying to pause a macro on a protected sheet, select 2 adjacent cells (initially protected), utilize an existing drop down box to select a name from the list, copy the name from the list into the range of cells, then re-start the macro. I had no problem when there was just one name (see John Smith below). I tried to use the InputBox command but needed to actually type in the name.
I recived the small job of making a template for my company for travel. I had spare time so I added in a feature so they can just e-mail it to the approite person from clicking a command button intead of taking the time to click the built in excel e-mail function and typing the addresse.
Anyway, this from tells the person who it is being e-mail to, what flights to book.
I have differnt command buttons to bring up differnt airline webpages, bascially a hyperlink but in command button form. Is there a way, just because i have time, to take the flying dates from excel, input them into the webpage which the command brings up, and search for the flights for that date, just by clicking a button in excel?
I was reading Box Office Mojo and wanted to know which actor would have the highest box office total if worldwide sales were accounted for and inflation was considered (for some reason they offer the data in 3 different formats but that is not one of them). I had previously only used Excel for simple records so I had to search your site for ways to write a few macros but I got everything working. I want to present the data.
It looks like embedding a spreadsheet in a webpage can be done but is there anyway I can add a feature so that if the person browsing the site clicks on a cell that cell's data will removed from consideration? I don't want the cell to actually display a "0" but if the background color could change to signify it was no longer being counted that would awesome. A lot of people argue about what movie should be counted toward an actors total box office record (starring roles only, supporting roles, voice work, cameos) so I would really like to be able to allow people to easily remove roles they personally don't think should count towards the total.
I am currently working on a VBA Macro in order to scrape data from a webpage into an Excel spreadsheet. My problem originates from the type of webpage that I am accessing. I am accessing a webpage that is used to filter the type of information, in which I have a Favorite (preset), which is the URL that I have included in the code. Once I get to that page, the code selects the proper function to load the data onto another webpage. It is from this webpage that the data I need to import into the spreadsheet is located.
Here is a step by step breakdown of my macro and the bolded/underlined portion .
Macro initiated - > filter webpage opened - > selection of filter preloaded - > data loaded into another webpage - > webpage with data opened - > | need to transfer data to Excel |
I have a simple text box I need to fill in with my email which I have managed to do very simply with this code;
Dim IE As InternetExplorer Dim sIEWindowName As String Set IE = New InternetExplorer IE.Visible = True
The layout looks like this with my email.value entered in.
I'm using Access 2007, but that is irrelevant for the VBA.
My problem is I can't enter the filename as easily. I have to use SENDKEYS to TAB over then a bunch of other tacky SENDKEY commands to load my file. Even though it works I don't feel it's reliable and would rather just fill the file name in a bit easier.
I used IE developer to show before and after using the BROWSE button to load the file location as seen in pic 1 and pic 2.
The code below has been my best attempt. It runs without error but it does not give me the result I need which is a file location for the application to pull.
have been trying to work out how to copy data from a website into a worksheet. For some reason the Data > Import External Data > New Web Query route does not work so I have tried the code below but cannot get this to work either.
What I am trying to achieve is to copy each of the various tables on the page into Excel.
Dim WebCopy As Object Dim WebtitleCopy As Object Set WebCopy = Sheets("Sheet2") WebCopy.Cells.Clear
I'm trying to enter some in a website and submit it, I'm using this code:
Code: Sub LoginToSite2() Dim IE As Object Dim IEdoc As Object Dim Password As Object
However I can't get to work for this website, I'm getting Run-time error "91" Object variable or With block variable not set I can only post the source code of the website (below). Also it contains frames, maybe that's part of the problem.
I've been working with this script to import and paste a webpage to a worksheet. Once the webpage is on a worksheet I can pull it into VBA easily enough but I was wondering if there's a way to "paste" the webpage directly into an array in VBA and skip the paste to worksheet step?
Set IE = CreateObject("InternetExplorer.Application") With IE .Navigate theURL IE.Visible = False End With