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!
 
LOL - My pleasure - Not the neatest solution, but it gets you there.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Webpage in Excel 3
Automate Excel URL Web Query 1
Input Data to Webpage 1
Trying to get DOM of web page 2
Importing several web pages with macro/VBA? 9
DisplyaAlerts Problem 2
EXCEL IN WEBPAGE 1
populating neighbouring columns based on drop-down choice 1

Back
Top