Check the query table definition, it is probably attempting to access an
external file that is not on your new machine.


--

Regards,
Nigel




"Leanne" wrote in message
...
Hi,

I have the following code to refresh a query and it works fine until I
install the file on another PC.

Private Sub CommandButton1_Click()
Sheets("Invoice Due").Activate
Range("A7").QueryTable.Refresh BackgroundQuery:=False
MsgBox "Refresh complete"
End Sub

It shows it failing on line
Range("A7").QueryTable.Refresh BackgroundQuery:=False

Can any one help?