Problem with simple macro... Error 400

[korcutt]

Howdy All,
I'm trying to update/refreash the data in the worksheet by using the following code... If I "click" the "Cancel" button on the file dialog I get the wonderful error 400 with nothing else explained!

Here's the code:

Public Sub RefreshData()
Selection.QueryTable.Refresh
End Sub


Any ideas out there?????

Thanks in advance,

Kevin Orcutt

 

[sweater_vests_rock]

korcutt.

i guess i'm confused. what file dialog are you getting? i've got a web query and i used your code to update without trouble...and without dialog box.

thanks. ben.

ps. welcome to the board!!!

 

[Zack Barresse]

Hello korcutt, welcome to the board!

You could always put an On Error Resume Next in your code above the offending line. Note that this is a fairly drastic measure as Excel will ignore all errors associated with your code. Generally, it's accepted practice to use some type of Error handler. If there is only one line, in this case, you don't really need something too elaborate.

If there are other actions you'd like to perform if there is an error, that can be done as well.

Is this what you are looking for?