|
Web Querry stopped working
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. |
Web Querry stopped working
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. 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. |
Web Querry stopped working
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. |
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. |
Web Querry stopped working
I just imported into xl2002 and it gave me the data AND refreshed.
I can send you the wb if desired. -- Don Guillett SalesAid Software "Madiya" wrote in message oups.com... 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. |
Web Querry stopped working
Thanks to look in to the problem. I was out of office for last 4 days
hance cound not reply you. I am still getting the same error. I have tried to get data from the built in web querry feature of xl but it still gives the same error. Since Don has tested and url works in xl2002, there must be something wrong in xl2003. Don, Could you please send me the workbook if possible? My mail is victor.vaz @ and balance id is relianceada dot com. I will try to refresh the same querry on my pc with xl2003. Regards, Madiya Don Guillett wrote: I just imported into xl2002 and it gave me the data AND refreshed. I can send you the wb if desired. -- Don Guillett SalesAid Software "Madiya" wrote in message oups.com... 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. |
Web Querry stopped working
Sent just now
-- Don Guillett SalesAid Software "Madiya" wrote in message oups.com... Thanks to look in to the problem. I was out of office for last 4 days hance cound not reply you. I am still getting the same error. I have tried to get data from the built in web querry feature of xl but it still gives the same error. Since Don has tested and url works in xl2002, there must be something wrong in xl2003. Don, Could you please send me the workbook if possible? My mail is victor.vaz @ and balance id is relianceada dot com. I will try to refresh the same querry on my pc with xl2003. Regards, Madiya Don Guillett wrote: I just imported into xl2002 and it gave me the data AND refreshed. I can send you the wb if desired. -- Don Guillett SalesAid Software "Madiya" wrote in message oups.com... 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. |
Web Querry stopped working
Don,
Thanks for your efforts. I have opened the file here with xl2003 and tried to refresh the querry you created. Unfortunatly, it still gives the same error. I will try to use the file at home today where I am having win xp and xl2003. If it works there then it sure that there is some goofup on my work PC. Thanks again. Regards, Madiya Don Guillett wrote: Sent just now -- Don Guillett SalesAid Software "Madiya" wrote in message oups.com... Thanks to look in to the problem. I was out of office for last 4 days hance cound not reply you. I am still getting the same error. I have tried to get data from the built in web querry feature of xl but it still gives the same error. Since Don has tested and url works in xl2002, there must be something wrong in xl2003. Don, Could you please send me the workbook if possible? My mail is victor.vaz @ and balance id is relianceada dot com. I will try to refresh the same querry on my pc with xl2003. Regards, Madiya Don Guillett wrote: I just imported into xl2002 and it gave me the data AND refreshed. I can send you the wb if desired. -- Don Guillett SalesAid Software "Madiya" wrote in message oups.com... 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. |
Web Querry stopped working
I have opened your file at my home pc and it works fine.
It means there is some problem on my office pc. Can you help me to identify the same please? Regards, Madiya Madiya wrote: Don, Thanks for your efforts. I have opened the file here with xl2003 and tried to refresh the querry you created. Unfortunatly, it still gives the same error. I will try to use the file at home today where I am having win xp and xl2003. If it works there then it sure that there is some goofup on my work PC. Thanks again. Regards, Madiya Don Guillett wrote: Sent just now -- Don Guillett SalesAid Software "Madiya" wrote in message oups.com... Thanks to look in to the problem. I was out of office for last 4 days hance cound not reply you. I am still getting the same error. I have tried to get data from the built in web querry feature of xl but it still gives the same error. Since Don has tested and url works in xl2002, there must be something wrong in xl2003. Don, Could you please send me the workbook if possible? My mail is victor.vaz @ and balance id is relianceada dot com. I will try to refresh the same querry on my pc with xl2003. Regards, Madiya Don Guillett wrote: I just imported into xl2002 and it gave me the data AND refreshed. I can send you the wb if desired. -- Don Guillett SalesAid Software "Madiya" wrote in message oups.com... 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. |
| All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com