Importing some Tables Q

G

Guest

from the code it seems to be trying to add a new
querytable. then at the bottom it is saying on one line to
..backgroundquery = true then further down
..refresh backgroundquery = false.
seems to have conflicts.
1. add then refresh???? once added all you need there
after is refresh. does your range finder id the
querytable? I would suspect that it is adding multiple
querytables over and over again.
2. true then false??? which do you want? background query
= false pauses other code until the refresh is complete.
try commenting the refresh line out and run the macro
let me know.
 
G

Guest

hi again,

it will balloon the file in size. the problem is the "add"
part. you are adding a new query each time you run it -
one over the other.
like i said. once added all you need to do after that is
refresh.
 
Top