I'm attempting to familiarize myself with pulling data from an online database into spreadsheets for manipulation. I'm relatively familiar now with pulling tables using webquery, etc. but my next feat is accessing data from sites which require some "input" before retrieving the desired data set.
Currently, I have a site which contains information and prompts for the "year" of information in a dropdown box. I've attempted to do this as indicated below, and was able to "select" a year, however the page doesn't load the data like it would if I were to manually click on it.
Sub GetEmissionsData()
Dim ieApp As InternetExplorerDim ieDoc As ObjectSet ieApp = New InternetExplorer
ieApp.Visible = True
[Code] ........
Separately I've tried setting the year using another method, but this just give an error
Sub GetEmissionsData()
Dim ieApp As InternetExplorerDim ieDoc As ObjectSet ieApp = New InternetExplorer
ieApp.Visible = True
[Code] .......
I'm not sure if the error is due to some issue with my code - or if "Label1" isn't the correct label for the dropdown / combobox on the site. I didn't post the site source on this page - but the URL indicate in this post is the one I'm interested in.
I have a list of questions that need to be filtered by the user and i was looking for an effective way to do it.
Column A is the question number Column B is the Question Category Column C is the actual question.
The user wants to use a dropdown box and select the question category. the results they will get are the question number and the question. there may be several questions within a category so all questions need to be displayed for the category that is selected.
(I havnt explored the use of a list as it gives the user the chance to display all the questions and i am trying to keep the viewing space that this list takes up to an absolute minimum). Also i have mentioned a dropdown box as these are very familiar to the user and so they could use it without the risk of user error. I have attached a list of the questions.
I have set of data in excel which is basically a table of workload and I need to be able to select someones name from a dropdown list and all the other names are removed.
I've attached a screen shot of an example, I want to be able to select any name from a dropdown e.g. Select Trevor and then only cells which contain Trevor are shown (i.e. the other names disappear). BUT all the jobs 1-10 and Stage 1-3 have to stay even if Trevor doesn't work on them.
I want to select more than one drop down box at the same time, and copy them as well as rename the cells they refer to.
For example: in A1 there will be a box with LinkedCell set to A1 and ListFillRange set to B1:B5. I now want a similar box in A2, with A2 as LinkedCell. However, when I copy past the box in A1, it still refers to A1 and B1:B5 (the last part is ok). I can easily change A1 to A2 by just changing it in the properties, but the thing is that I also need these boxes in A3:A100. Is there any faster way of changing this?
Also, the ListFillRange might expand in the future. Therefor I would like to know if its possible to select the boxes in A1:A100 and change the ListFillRange to B1:B6 for all at once.
I have a dropdown box to choose a category. When the category is chosen it displays the relevant course names which corresponds to that category (this could be 1 course up to 10 different courses). Along with that course name it gives the relevant course overview.
This works exactly how i want it to. (thanks to Zbor from a previous thread)
I now want to expand further and give the corresponding course objectives for each course that shows up in the results.
I have attached a workbook as its much easier to see the dropdown box working.
Sheet 2 is the working sheet and sheet 1 will contain all the source data. I have highlighted the columns affected in Blue Blue column on sheet 1 will have the course objectives on the same line as the course they belong to Blue column on sheet 2 is where they will be displayed when the correct category selection is made.
The course objectives are unique to the course title and course overview.
In my IE site there is a field which is a dropdown field with the value 'Not Known' and 'Specified Date'. If I select 'Specified Date' another field named 'Date' becomes visible where I can give a date. I was able to ensure that the value 'Specified Date' is selected using the following statement:
IE.document.GetElementById("startDateBasis").Value = "SpecifiedDate"I also was able to populate the date field with the statement: IE.document.GetElementById("startDate").Value = SOA
Where SOA is populated with the date string I need to be given as input in IE.
My issue though is that, eventhough the data is provided by the macro the field 'Date' is not visible. So I have no way to know if the input was succesful until I submit the screen. I think I read somewhere that this is because of the way datebasis is populated.
How to get the field 'Date' made visible if datebasis is given as 'Specified Date'?
I've made a drop down list and when I select multiple cells and choose from the drop down list, it only fills one. Here's pictures:
So in that first picture, I've selected multiple cells. But when I drop down the menu and click my selection, this happens:
Why is it that all the cells I've selected does not fill with the option that I chose from the drop down. I highly doubt that I have to manually click all the ones I want to fill with what I choose from the drop down list.
I have 5 cities and each city has a set of data in separate tabs. Right now i have data pulled for all 5 cities in a single sheet but its too cramped up..
I want to use a drop down list (data validation) and if any of the 5 cities are selected in the drop down, the data from that particular city (tab) should be pulled up. This way my sheet size will be reduced 5 time which will look good.
A common v lookup wont work because the data has to be pulled from 5 different tabs for 5 different cities.
Basically on a summary page, on sheet 1 say I have a formula which picks up the unit cost (I have this as an array across 5 years)
What I then want to do is multiply this by a volume driver. I have a list of these drivers on a seperate page, so for convenience lets say DRIVER_01,DRIVER_02 etc. These are also 5 years arrays.
So what I want to do it be able to select which driver I want to use for volume on the summary, from a drop down box I have set up, and then the formula pick up that named range, and not just recognise it as a text cell.
I need the ability to change the driver in the future, hence the drop down box. I can also get the unit array part to work fine, I'm just struggling to get this driver array to work..............
I'm trying to make a spreadsheet that can be used to easily build a collective list of steps, for a user to read and follow line-by-line.
I want a source sheet of "steps" that I can change over time, and the resulting tabs that reference the source sheet get updated/populated automatically.
I've pieced together some VBA code from other sources, which kind of does what I want it to:
VB:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row > 1 And Target.Column = 1 Then Dim SourceSheet As Worksheet Set SourceSheet = ActiveWorkbook.Sheets("Steps") Dim TargetSheet As Worksheet Set TargetSheet = Target.Worksheet Dim c As Integer Dim Source As Range
[Code]...
But there are some problems:
1) The data auto-populates into a row. It would read better if each step was in the same column, meaning rows would need to be automatically added upon selecting something from the drop-down list. The number of rows that need to be added vary based on the number of steps in the source sheet, for the selection made from the drop-down list.
2) If you make a change to the source sheet, my goal is to have the other sheets referencing the source sheet's lists of steps update automatically, so you only need to update the steps in one spot and everything you've built from them gets updated instantly. Currently, you must select a different choice from the drop-down list, and then change it back, before it populates the "new" steps from the source sheet.
This is my first time using VBA.
What I have so far is attached: testAutoPopulate.xlsm
I have a dropdown list in C24:C50 (=CategoryList) with data validation and a sub list in D24:D50 (=ItemList) with data validation. I am looking for a way to have code automatically run after selecting an item in the data validation dropdown list in column C.
Example; I click on C24 and make a selection. I what it to trigger code that would move me to D24 and open up the data validation list in D24. After the selection in D24 I would like it to move me back and down 1 row to C25. I have not found anything directly related to this but I have found that code can be run after a selection in a valadition list.
I have a spread I use daily where I need to go to a series of links on a site and extract data- all that is programmed. But it's a site that requires I first be logged into my account.
Code: Sub AcctLogin()
Dim a As String Set ie = CreateObject("InternetExplorer.Application") With ie .Visible = True
[Code] ....
The above code works, but it opens up an IE window. I'd just like it to log in in the background so I don't have to deal with a new window..
I am looking to pull information from certain websites and put them in excel. I'm not quite sure where to start. I have tried the search option but it is not returning anything.
I am wanting to be able to lauch www.fafsa.gov from within Excel. In other words I want to be able to put a button on screen and when the user clicks on the button it will record some statistical data and then lauch the website. I know how to do everything except lauch the website. Can you lauch a website using code from within Excel.
I have as list of company registration numbers and would like you use code to input them into the companies house website - Failure Page
Comany Reg No example - 03292899
In order to get the date of the last accounts.
The problem is then when you submit on the site i cant see how it passes the company reg number through to load the next page. If I can get to the page then i have code to get what i need from the page but i cant find a whay to get the to page that i want.
how to use the example reg number to access the companies house page for this company.
I am trying to bring in a web page into excel but when it brings it in it misses the little football .gif. My code is like this if I don't get this gif its another bunch of work to read through the data.
Sub Get_playbyplay()
Dim cur_year As Integer Dim game_url As String Dim cur_row As Integer Dim site_url As String Dim paste_row As Long Dim Heading As String Dim q1_row As Long Dim find_last As Long Dim space_count As Integer Dim prev_year As Integer
I looked at the source code of the website and realized that if you notice (above) that the variables listed in the link (i.e year, month, day) are exactly what i need to change in order to get the data for a specific date. how can I accomplish this using VBA. so say I have in on an excel sheet year in column A, month in column B, and days in column C (time interval is constant so we don't have to worry about stime and etime). and i run the macro and it loops through each row taking year,month,day for all rows and saving the data as .csv or xls files?
I'm trying to automate some webscraping on a website that requires a login, and was wondering how I would do so using Macros with a specific username password somewhere in the spreadsheet, lets say B2, and C2 respectively. The website I'm trying to login is this; http://underground.chacha.com/account/. I think I have most of the scraping figured out; its just the log-in for now.
retrieving data from financial website databases like yahoofinance.com and bloomberg.com. I'm trying to make an automatic stock analysis model to read from the website database and retrieve the data into excel sheets. For example, when opening the excel model the user gets a popup to enter the stock ticker, the user enters the ticker and gets a set of data. Is this do-able in excel?
I'm trying to put an excel sheet on to a website. The website allows HTML snippets and I know how to save the excel sheet as a webpage but I don't know how to transfer the webpage I've created on to the website. It asks me to post the snippet but I don't know what it wants? What is the snippet?
