View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Web Querry stopped working

More than likely the web site has re-organized where they keep the data or
the pages that display the data. I had no problem opening the link or
querying the data into a worksheet. This has happened to me several times
and I had to edit my query in Excel to point to the new path and possibly
edit any code that processes the data because it may import differently.
Good luck,
Mike F
"Madiya" wrote in message
ups.com...
I have also noted the following error message.

Unable to open
http://www.rbi.org.in/scripts/bs_vie...n.aspx?Id=5642. The
Internet site reports that a connection was made but the data is not
available.

This error comes for each and every site.
I am using Office 2003 with windows 2000.

Please help.
Regards,
Madiya122
yahoo.co.uk





Madiya wrote:
I have a web querry in VBA macro which runs multiple time depending on
the no of data types provided and fatches wab tables in my excel sheet.
Till last week it was working fine as expected. BUT now it stopped
working. I have confirmed visiting the wab pages and all the wab tables
and URLs are same. But still wab querry returns no data. I have checked
my pc for virus by 4 different antivirus which detected no virus.

What's wrong? Have I changed some setting by mistake? But I know I have
not changed any setting.

Please Help.

Regards,
Madiya.