I have an excel application that queries a web site and downloads certain
tables as html.. The tables contain hyperlinks, the location of which you
can view if you mouse over them and by clicking on the cell, you can also
follow these links.

But what is actually displayed in the cell is the "friendly name". For
future programming, I would like the actual link location displayed (either
in these cells or different cells)... Does anyone know a way to do that?

I've tried edit query, but excel vba learn doesn't record the link location??