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.

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.

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.

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.

I just tested this in xl2002 for the url given.
I right clickedimported into excel.

It refreshed.

--
Don Guillett
SalesAid Software

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

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.

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.

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.

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.

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.

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.