Hyperlink help for a Newbie
 

I am running Excel 2000 and need to capture a BUNCH of data from an online
database (name, address, company). There are about 15,000 records that I
need to capture.

The problem is that I have a hyperlink to each record but don't have access
to the entire database all at once, i.e., you click on the hyperlink and it
opens the web page and displays the information. I would have to click on
each and every hyperlink, copy the data, paste it into the spreadsheet,
transpose it from columns to rows and then do it all over again for 15,000
records! I would be drawing Social Security before I completed that task
manually.

Can a macro be written that will automate this procedure?

Following is a sample of the data. The URL actually has an ID associated
with it (it's the last digits of the address). You would click on the ID
and it would hyperlink you to the URL.

http://www.memberbase.com/ncrec-new/...hdb.asp?212598 ABAR,
NARIMAN
http://www.memberbase.com/ncrec-new/...hdb.asp?130751 ABBAT,
R MARINA
http://www.memberbase.com/ncrec-new/...hdb.asp?183382 ABBEY,
RICHARD C
http://www.memberbase.com/ncrec-new/...hdb.asp?144632 ABBOTT
JR, R CHARLES
http://www.memberbase.com/ncrec-new/...hdb.asp?212402
ABDELLA, RICHARD M
http://www.memberbase.com/ncrec-new/...hdb.asp?174271
ABDULLAH, MARTIN F
http://www.memberbase.com/ncrec-new/...chdb.asp?48655
ABERNETHY, DIANE J
http://www.memberbase.com/ncrec-new/...chdb.asp?78940
ABERNETHY, MARTHA B
http://www.memberbase.com/ncrec-new/...hdb.asp?176794 ABNEY,
NORMAN D
http://www.memberbase.com/ncrec-new/...hdb.asp?201267 ABOOD,
JOHN D

Any help would be greatly appreciated!!

TIA

Chuck

Hyperlink help for a Newbie
 

Hi Chuck,
I have doubts that would be legal though since it is a public record, you would
normally see something specific as to use. In any case you can purchase a list.
https://www.memberbase.com/ncrec-new/rosters/mains.asp
for a lot less trouble than you would be causing yourself and their
servers.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chuck Jurgens" wrote in message . ..
I am running Excel 2000 and need to capture a BUNCH of data from an online
database (name, address, company). There are about 15,000 records that I
need to capture.

The problem is that I have a hyperlink to each record but don't have access
to the entire database all at once, i.e., you click on the hyperlink and it
opens the web page and displays the information. I would have to click on
each and every hyperlink, copy the data, paste it into the spreadsheet,
transpose it from columns to rows and then do it all over again for 15,000
records! I would be drawing Social Security before I completed that task
manually.

Can a macro be written that will automate this procedure?

Following is a sample of the data. The URL actually has an ID associated
with it (it's the last digits of the address). You would click on the ID
and it would hyperlink you to the URL.

http://www.memberbase.com/ncrec-new/...hdb.asp?212598 ABAR,
NARIMAN
http://www.memberbase.com/ncrec-new/...hdb.asp?130751 ABBAT,
R MARINA
http://www.memberbase.com/ncrec-new/...hdb.asp?183382 ABBEY,
RICHARD C
http://www.memberbase.com/ncrec-new/...hdb.asp?144632 ABBOTT
JR, R CHARLES
http://www.memberbase.com/ncrec-new/...hdb.asp?212402
ABDELLA, RICHARD M
http://www.memberbase.com/ncrec-new/...hdb.asp?174271
ABDULLAH, MARTIN F
http://www.memberbase.com/ncrec-new/...chdb.asp?48655
ABERNETHY, DIANE J
http://www.memberbase.com/ncrec-new/...chdb.asp?78940
ABERNETHY, MARTHA B
http://www.memberbase.com/ncrec-new/...hdb.asp?176794 ABNEY,
NORMAN D
http://www.memberbase.com/ncrec-new/...hdb.asp?201267 ABOOD,
JOHN D

Any help would be greatly appreciated!!

TIA

Chuck