runtime error 1004 HELP PLS

[Marcelo P]

I have excel macro that when I run it for the first time it works
fine, but all the even number of times I try to run it, I receive
runtime error 1004".
For example, the first time it runs ok, the second it crashes, but the
third it runs ok again, and so on.

Can anybody help me with this problem.

Thanks a lot

The code is below

Sub new()

qURL = "http://sitesafari.com/api/?
action=getGrps&usnm=mpochin&pw=master&format=HTML_Table"

With ActiveSheet.QueryTables.Add(Connection:="URL;" &
qURL, _
Destination:=Range("A1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True


End With
End Sub

 

[Gerigto]

http://support.microsoft.com/kb/210684

 

[Marcelo P]

http://support.microsoft.com/kb/210684
--
TG












- Show quoted text -

Thanks Gerigto,
I followed the instructions but I cannot get it to work,
Could anybody tell me how to modify the code so it will work.

Thank you all