Hello,

There are two parts to my question:
1. I want to substitute cell contents for part of an url in a we
query.
e.g how could I substitute the "02474" i
http://www.hemscott.com/equities/com...y/key02474.htm for a valu
specified in a cell in my sheet.

2. Using the table at the url above, I want to pull only three piece
of data to be placed in sequential columns:A."Abacus Group" B."fin x
(6.80p)" C."10-Dec-03".


Any help appreciated greatly.

Bertie

--
Message posted from http://www.ExcelForum.com