L
Leanne
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?
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?