Copy and paste Internet information into Excel 2003
 

I have a database of 220 names. Each name has a hyperlink to an individual
internet page that contains each person's address, telephone number, email,
etc. Is there a way to automate clicking on the hyperlink, copying the
internet information and then pasting it into an Excel 2003 spreadsheet? I
tried recording a macro, but the paste failed. I got a run time error of
1004. Thanks very much in advance.
--
Sincerely, Michael Colvin