Posted to microsoft.public.excel.programming

Leanne

external usenet poster

Posts: 87

query code failes on different PC

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code to query data	dkenebre[_9_]	Excel Programming	0	August 13th 05 07:03 PM
VB macro code for SQL Query	Dan[_39_]	Excel Programming	5	July 19th 04 02:56 PM
VB Code for MS Query	Gustavo[_4_]	Excel Programming	3	June 25th 04 08:57 PM
Code Query	JohnUK	Excel Programming	4	June 2nd 04 09:40 PM
query source code	Mel[_7_]	Excel Programming	1	August 29th 03 11:24 PM

All times are GMT +1. The time now is 11:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us