Ok thank you for that info. The refresh keeps failing on this line so
thought it may be something but turns out to be nothing.
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)


"FSt1" wrote:

hi,
if the background guery is set to false then code execution is halted until
the refresh is complete. otherwise if there is additional code after the
refresh command that may try to manipulate the query data and background
query is set to true(default is true), the additional code will execute and
start manipulating query data before is has refreshed. always best to let the
MSQ complete the refresh.

regards
FSt1

"Leanne M (Aussie)" wrote:

Range("A7").QueryTable.Refresh BackgroundQuery:=False

Can someone please explain why this is = False.

This line of code is for refreshing a query so I do not understand why it is
False.

Every time I try to refresh this query on a computer that is not the
development pc I get an error which points to this line of code after I have
entered the parameters.

I have created a new data source on this pc to point to the same file as the
original pc and called it the same. Is there something else I am not doing?
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)