Access Query only at the end

[kilian]

Hello,

I wrote a macro with Vba on Excel 2000.
My Excel's page updates its cells's values with a query on an access's
database. And my macro updates automatically this query and does any
operations with the values of the cells....

The problem is that the requery on the macro executes itself only at the
end of the script, but I wrote this instruction at the begining of the
script:

'''''''

Range("A1").Select
Selection.QueryTable.Refresh

'''''''

I don't know why this instruction executes only at the end of the
script... The macro execute operations on cells which are not updated...

Thanks....

 

[kilian]

Aaah it's ok.
I have to write:
Selection.QueryTable.Refresh BackgroundQuery:=False

Thanks...