Displaying the URL's of imported webpages

S

Shatin

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
 
K

Ken Wright

Hold down CTRL, right click on the sheet and do Edit Query and then hit c the
second it comes up. The address is what is active when you do this, so that
should copy it to your clipboard. Then just paste into your sheet somewhere.
 
S

Shatin

Ken,

It took me a few attempts to get it right but the trick does work. Many many
thanks!
 
Top