Displaying the URL's of imported webpages
 

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

Displaying the URL's of imported webpages
 

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Shatin" wrote in message
...
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.587 / Virus Database: 371 - Release Date: 12/02/2004

Displaying the URL's of imported webpages
 

Ken,

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

--
-Des
"Ken Wright" wrote in message
...
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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Shatin" wrote in message
...
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.587 / Virus Database: 371 - Release Date: 12/02/2004

Displaying the URL's of imported webpages
 

LOL - My pleasure - Not the neatest solution, but it gets you there.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Shatin" wrote in message
...
Ken,

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

--
-Des
"Ken Wright" wrote in message
...
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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Shatin" wrote in message
...
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.587 / Virus Database: 371 - Release Date: 12/02/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.588 / Virus Database: 372 - Release Date: 13/02/2004