Importing Data from the internet.

CJM

New Member
Joined
Sep 16, 2002
Messages
3
Hello,

I wish to import data from the web to an excel spreadsheet for analysis. I can achieve what i need no problem, but i was wondering if there was some way of automating the process as i usually require data from up to 50 urls at one time.

Is there any way to set up web address parameters and with one keystroke import the data from each of the address's?

I'm using excel 2002 and an example of the data I import is http://www.tabq.com.au/2002/09/17/VR04.html

The other url's in this example would be include the last four letters/digits VR01 through VR08.

Thanks in advance.
CM
This message was edited by CJM on 2002-09-17 01:57
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
I used to do something like this to automatically refresh data in Excel..

Set shFirstQtr = Workbooks(1).Worksheets(1)
Set qtQtrResults = shFirstQtr.QueryTables _
.Add(Connection:="URL;http://www.marketprices.ft.com/ftpages/mp_cucctall_rate.htm", _
Destination:=shFirstQtr.Cells(1, 1))
With qtQtrResults
.WebFormatting = xlNone
.WebSelectionType = xlSpecifiedTables
.WebTables = "1,2"
.Refresh
End With
 

CJM

New Member
Joined
Sep 16, 2002
Messages
3
Thank you LASW10.

At this stage i'm not looking at 'auto refresh' however i may require it in the future.

Regards
CM
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Sure but this should be picking up the tables from the internet and putting them into Excel (you can remove the refresh).
 

CJM

New Member
Joined
Sep 16, 2002
Messages
3
Hello Again,

The problem I have is i am scarcely conversant with VB. I understand from the code you have given it will display the data from that one particular web site. What I am looking for is data from a number of url's, i.e one for each race per day.
I hope this makes sense.
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
You can replicate the code and simply change the URL's (you will need to know all of them to do this automatically) - and then change the destination of the returned data.
 

Forum statistics

Threads
1,144,360
Messages
5,723,903
Members
422,526
Latest member
edminty84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top