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