If I rretrhad the URL I can write some code. The best solution would be to
have a control button which you can activate. The control button can open an
internet explorer application which can automatically retreve the data from
the URL and place the data into you worksheet.

If the URL is not public then I can send you some examples of code that
would perform the task. Working with the internet explorer application is a
litle tricky b eause every webpage is different. Knowing html will help.

"Doug" wrote:

I have a hyperlink to a web database. Up till now I have been clicking on the
hyperlink and once it takes me to that web page I then include a cell
reference from excel at the end of the web address to obtain the data that I
need. What I am hoping is that I can have excel somehow include or attach
the text in the cell to the end of the hyperlink when I click on the cell.
This would be very helpful. Is this possible?
--
Hope your having a great day!