VBA- Pulling Data From Website

Aug 24, 2008

I went through the thread http://www.mrexcel.com/forum/showthread.php?t=302438. I have similar problem of pulling the data from http://www.nseindia.com/ site. Could you please help me?

The navigation to the page required is as below.

http://www.nseindia.com/ > Equity > Historical Data > Security-wise data >

eg. NSE Symbol: RPL, Series: ALL, From date: 01-01-2008, To date: 01-05-2008.

After clicking on the 'Get Results' button it navigates to the page with tables. At the end it says "Download file in csv format". upon clicking this a csv file opens. (http://www.nseindia.com/content/equi...-2008RPLXN.csv)

I need this page to be opened in Excel sheet. How should I go ahead?
(Basically I need historical stock data csv files of various stocks)

Even though a simple web query opens the page, it do not work if the parameters (stock name, date) are changed.

I found that the last resulting page in csv is using a "REFERRAL URL". Could this be a problem? How to get around?

I know little bit of VBA and can further work to pass variables.

ADVERTISEMENT

Pulling Data From Website When Url Changes

Feb 8, 2008

I have written a macro to pull in data from a website each day. However the macro falls over because the end of the url changes slightly each day as the website provider updates the information. Unfortunately there does not appear to be a logical pattern to the number change in the url and so I donít think I can pre-empt what the change will be. The path through the website remains the same, but the url changes as a new csv document replaces the old one. Is there any way of writing the macro so that it opens/picks up the current url rather than a fixed url?

View 9 Replies View Related

Pulling Data From Website Within Userform?

Dec 22, 2012

I have a user form that will navigate to a website where the user can find the latitude/longitude coordinates of a desired point.

What I would then like to do is "pull" the latitude/longitude into cells B1 and B2 respectively.

I have attached the workbook.

[URL]

View 9 Replies View Related

Pulling Eternal Data From A Website

Feb 21, 2010

I have a bunch of lists I would like to copy from a website. I'm trying to copy them into excel using an external data query but the information I'm trying to grab doesn't export. I tried selecting various tables within the webpage.

View 9 Replies View Related

VBA To Log Into A Website

Jun 25, 2012

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..

View 2 Replies View Related

Getting Postcodes From Website Using VBA

May 19, 2014

I am desperately trying to get full postcode lists from two websites: [URL] .... and [URL] ........

The latter of the two is harder to get (I'm told) so it could also be available at: [URL] .... by selecting only the "Collect+" stores.

View 2 Replies View Related

Getting Info From Website Using VBA

Aug 5, 2014

I am using VBA to open an IE page and try to get some info however i cant seem to grab it

This is the code i have..

[Code].....

I have inspected the code from the website and it is this

[Code] ........

The problem is i dont know how to get the info in the "Metaname, ICBM".

View 7 Replies View Related

Get Information From Website

Dec 16, 2009

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.

View 3 Replies View Related

Launch A Website

Jan 14, 2010

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.

View 4 Replies View Related

Using VBA To Get Details For A Website?

Apr 23, 2013

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.

View 2 Replies View Related

Bringing In .gif From Website

Aug 11, 2009

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

'Main loop each loop one season

View 9 Replies View Related

Extracting Data From A Website

Jul 30, 2013

I am trying to extract data from a website:

[URL] .....

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?

View 1 Replies View Related

Any Way To Filter Valid Website?

Jun 12, 2014

I have list of various web site and i want to keep only valid site . How it is possible ?

View 1 Replies View Related

Logging In A Website With Macros

Dec 12, 2008

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.

View 2 Replies View Related

Retrieving Data From A Website

Jul 31, 2013

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?

View 2 Replies View Related

Copying List From Website

Oct 30, 2013

I wonder if there is some way to copy a list from a website to an excel sheet.

I am referring to this particular website.

[URL]...

There is a cashflow savings calculator on this site.

I want to copy the categories stated in step 1 of this calculator to an excel sheet.

Is there some easy way to do this?

View 2 Replies View Related

Put Excel Sheet Onto Website?

Mar 3, 2014

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?

View 4 Replies View Related

Login To Website Using VBA Script

May 19, 2014

I'm trying to login to [URL] ...... using VBA. I cannot share login details. How it might be able to work?

View 3 Replies View Related

Fetching Data From Website?

Jun 20, 2014

I have list of url in a column. I want to fetch data from all the links and store it in a excel sheet.

I have written code, the code fetches only 1 links data at a time. I want to loop that vba macro and fetch all the data at a time.

View 4 Replies View Related

Scraping Website Into Excel?

Jul 9, 2014

I have an excel sheet that has a lot of APN (parcel numbers) on it. I would like to run that through the assessors page [URL] to get the address and owners name. It seems like a very simple thing to do, but... How would I make it run each parcel through the assessors page to get the name and address information. Is there a tool I can install into Excel to make this easier?

View 7 Replies View Related

View Website Tags?

Dec 21, 2009

I am building an application through Excel to update specific internal website information. My question is, is there an easier way to identify and view the tags on a web page without having to right-click and "view source"?

View 2 Replies View Related

Selecting From Website Dropdown Box

Aug 3, 2012

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.

View 4 Replies View Related

VBA - Save File From Website

Nov 19, 2003

I ran into a problem with the following code

Dim URL As String
URL = Worksheets("References & Resources").Range("URLMSL")
Dim IE As Object
Set IE = CreateObject("internetexplorer.application")
IE.Navigate URL
IE.Visible = True

My problem is that on most of the workstations here, it will open internet explorer, then open the file in Excel. I just want it to Save the file.

View 9 Replies View Related

Using VBA To Upload Image To Website?

Jun 23, 2013

I would like to write a script to upload image to this website. These images are in my local directory and their names are defined in excel file (cell J2:J5)This button in this website using flash so it make me hard.

i attached the file here

Using VBA to upload image to website

View 2 Replies View Related

Scrape File From Website?

Mar 14, 2014

I am trying to open/save a csv file from a website but the URL only takes me to the page the file is hosted on then the file has to be clicked and it asks you to save it. It doesn't appear that it is a shortened URL and using Firebug I have gone through the HTML trying to find a link to the file but haven't. These files are date specific and ultimately the macro will be used to scrape different dates.

The URL: [URL] From that you will select the year>month>day number>download file

View 5 Replies View Related

Find A Word In Website Using VBA?

Jun 3, 2014

I want to find a word in website using vba. below is my code but its not working in last.

Sub com411()
Dim tx As Object
Set ie = CreateObject("internetexplorer.application")

[Code]....

View 2 Replies View Related

VBA To Publish A Worksheet To Our Website

Nov 7, 2007

We are a construction company.
We travel and do work local.
Some employees that have access to the internet at home.
Some have access when they stay at hotels.

What I would like to do is give them a work schedule on our website.
I would really like to do this using VBA.
Is it possible to save the worksheet and send it to our website?
I would love to attach a Macro to a button so the person, after updating the schedule, just punches that button and the updated sheet goes on our website.

View 9 Replies View Related

Can A Macro Contain A Link To A Website

Jul 12, 2009

I have two different worksheet that if data is changed then the user needs to go to the company's website to update information there as well.

Can a macro look at a range of cells and if a change is made then a message box would pop up and if the user said yes then they would be directed to the company's website.

View 9 Replies View Related

Extract Data From A Website

Jan 8, 2010

Is it possible to extract data from a website into an excell workbook using data from the workbook?

I have rough workbook that i gather data from 3 different websites to calculate a rough market value for DVDs that I buy and sell. I am good with excel but have no idea about importing data into it.

Currently I copy and paste from the sites on an as needed basis but it is a slow slow task when I have several dozen or more to do per hour.

View 9 Replies View Related

Importing Data From A Website

Jun 3, 2003

I wish to surf to a website and retrieve the bottom entry in a column The column updates dynamically with a new number added to the bottom on a daily basis.

Here is the website URL: http://global-view.com/fxhist.TXT.

The column I am interested in is the second column from the left under the History section. The column contains close prices for the currency symbol EUR/$.

View 9 Replies View Related

VBA - Save A File From A Website

Nov 19, 2003

problem with the following code

Dim URL As String
URL = Worksheets("References & Resources").Range("URLMSL")
Dim IE As Object
Set IE = CreateObject("internetexplorer.application")
IE.Navigate URL
IE.Visible = True

My problem is that on most of the workstations here, it will open internet explorer, then open the file in Excel. I just want it to Save the file.

View 9 Replies View Related

Copying Data From A Website ..

Apr 19, 2006

I have managed to manipulate a website by entering some dates into the input boxes then go to another page with the information I need. I am wondering if anyone knows a macro I can use to copy the data directly to a new worksheet?

my code is below ...

View 9 Replies View Related

Searchable Database On My Website?

Sep 14, 2006

I am a DJ and I want to allow my prospective customers to view my music library, while preventing my competition from printing a copy, or posting my library as their own. I think I can accomplish this by having a Java (or similar) interface on a page of my site that allows the user to search songs by title or artist. However, I am lost as to how to make that happen.

A competitor has something pretty close to what I want, but cannot get enough info about how to do it myself when viewing his source code (http://www.houstonkaraoke.com/search-pro/prodb.htm). I would like something a little more asthetically pleasing. My DB is in Excel 2000 and I am running XP.

View 3 Replies View Related

Access Banking Website

Jul 18, 2007

if there is a library that supports interacting with a
website via VB? I'm trying to write a program that automatically logs
onto my bank account and downloads my monthly statement.

My searches for "VB web access" seem to only bring up a lot of stuff
about VB Access databases.

View 9 Replies View Related

Getting Website Data - Multiple Tabs

Mar 8, 2013

I've only recently ventured into the VBA scripting and am finding it quite exciting. After doing some trivial stuff, I'm trying to work with websites. Currently, I'm trying to pull data off of a website which poses a form which has to be filled first. I've been successful in filling the form and clicking submit, through the code, but the site opens the results in a separate tab in IE. I am unable to make it go to that tab and copy-paste data from there.

Secondly, instead of just blindly copy pasting, it would be better if the data is pasted in a more readable format (as on the website). The following code is plainly copying and pasting the data as-is and hence rendering it unreadable:

VB:
.ExecWB 17, 0
.ExecWB 12, 2
.PasteSpecial Format:="Text", link:=False, DisplayAsIcon:=False

View 1 Replies View Related

Taking Data From Website To Spreadsheet?

Jun 21, 2013

I am an excel novice trying to create a list of local churches. There are several online lists that I am taking the data from but, being a novice, I am entering the data manually. How to set up a method to bring the data into excel and order it where I want it.

I am attaching the spreadsheet.

These are the websites I am taking my data from: [URL]

View 3 Replies View Related

Paste Address List From Website

Jul 26, 2013

I'm trying to copy a list of addresses from a website and paste that into Excel. I'm having problems because Excel doesn't separate each address. The original website address list has clear separation of addresses (returns, tabs, etc). For example:

John Doe
111 Fox Street
Van Nuys, CA 91403 (See there's no separation between addresses)
Michael Smith
2759 Apple Street
Encino, CA 93727

This is the website where the address list comes from: [URL]....

View 14 Replies View Related

Vba Code To Refresh Website Link?

Apr 13, 2014

what i am trying to do is...... i have a website link which i kept open. For every after 5 mins my session logsout.

is there any alternate solution or a vba code which keep refreshing the page once in 4 mins.

View 1 Replies View Related

Macro To Lookup Website Using Any Browser?

May 12, 2014

I have the following code that works well with IE but I use chrome almost exclusively. how to tweak this code so that I can pull up a website with my default browser which is chrome instead of IE.

View 2 Replies View Related

Macro To Click On Link Within Website

May 15, 2014

I am looking for a macro that can click on a link within a website. This link produces a print window. Below is some similar code that I have used before but this link does not have an ID so I am not sure what to do. I am also posting the HTML Code and a jpeg of the HTML code.

[Code] .....

HTML Code: 

<TR>
<TD height=24 noWrap>
<IMG alt="" src="/SharedFilesCB/LeftMenuControl/Images/spacer.gif" width=2 height=1>
<A onclick="if (bIsFrameLoaded) PrintReportClick(); return false;" onmouseover="status='';return true;" class=leftMenu href="">print reports</A></TD></TR>

F12_2014-05-15_17-22-08.jpg

View 2 Replies View Related

Count How Many Times A Particular Website Was Repeated

Oct 23, 2008

I'm just using the "=COUNTIF" function to count how many times a particular website was repeated, but I have no idea if such website is among the top five that appear the most throughout. Finding that manually, given the ridiculous size of the data provided, would take days!

View 4 Replies View Related

ADVERTISEMENT