Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

edit web query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KIG - 13 Sep 2007 12:10 GMT
This was working a few days ago and now doesn't.  When you try and Edit a Web
query the web query box pops up with the correct web address, but you get a
message ... "Navigation to the webpage was cancelled". The Web Query does
work as it is on automatic refresh in the background and pulls back the
correct data, I just can't edit it.  I can run IE7 with the same address and
it works fine.  I also cannot add a new web query as I only ever get the
default IE web page displayed.

the address is  http://uk.finance.yahoo.com/d/quotes.csv?s=DGO.L&f=c1

Any ideas? I suspect an Windows automatic update has downloaded a "fix" and
broken it
Don Guillett - 13 Sep 2007 13:53 GMT
If you like, send me a workbook with examples and I will take a look

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> This was working a few days ago and now doesn't.  When you try and Edit a
> Web
[quoted text clipped - 12 lines]
> and
> broken it
KIG - 17 Sep 2007 17:32 GMT
I found a work around by bringing the value back as HTML not in a csv file.

Using

http://uk.finance.yahoo.com/d/?s=DGO.L&f=c1 

instead of

http://uk.finance.yahoo.com/d/quotes.csv?s=DGO.L&f=c1

It must be a problem with opening a csv file from a web query, probably
something to do with security.

Regards to all
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.