Help needed with Run Time Error 1004

M

Manesh

I am running a EXCEL macro to automate web query. It is a simple macro. The
trouble is sometimes it runs fine but other times it gives run time error
1004. Could some one suggest any solution. Thanks in advance

Here is my code:

Sub Try200()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://finance.yahoo.com/q/pr?s=[""Quote"",""Enter Stk Symbols""]", _
Destination:=ActiveCell)
.WebTables = "33"
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

runtime error 1004 HELP PLS 2
Run Time Error 1004 with Excel Web Query Macro 0
Web query..... unable to get data ? 2
Macro / VBA help 4-5-12 1
How to obtain the row count of a QueryTable from a Web query 4
VBA Coding Help for Beginner 0
Paste string on a cell to New Web Query URL 1
Syntax error? 2

Top