Displaying the URL's of imported webpages

  • Thread starter Thread starter Shatin
  • Start date Start date
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
 
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.
 
Ken,

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