My friend has given me a workbook with several worksheets. Each worksheet is
linked to a webpage. When I refresh the worksheets, they work fine. Trouble
is I don't know to which webpages the worksheets are linked, and I want to
know what the URL of each webpage is. However, when I choose Data | Import
External Data | Edit Query to check what the URL is, the URL is quickly
redirected to another web page. I never get the chance to see what the
original URL is. How can I, by using VBA or otherwise, display the URL's of
the linked worksheets?

TIA