Frank Kabel...need your help

[Guest]

I've got MSQuery setup to retrieve data from an external database. I have a macro that automatically refreshes the data when the file is open. It's very cool because I've got it setup to prompt for the parameters (e.g., beginning date, ending date)

I'd like to complete the automation of this spreadsheet by telling Excel to refresh all the pivot tables in this workbook, AFTER the data is DONE being downloaded.

 

[Frank Kabel]

Hi Jonathan
first: you may use a different header for this kind of
postings: Just stae your problem and don't address a
question directly to one of the regulars. Others may just
simply disregard this kind of postings

For your question: Insert the line
activeworkbook.refreshall
after your code

-----Original Message-----
I've got MSQuery setup to retrieve data from an external

database. I have a macro that automatically refreshes the
data when the file is open. It's very cool because I've
got it setup to prompt for the parameters (e.g., beginning
date, ending date).

I'd like to complete the automation of this spreadsheet

by telling Excel to refresh all the pivot tables in this
workbook, AFTER the data is DONE being downloaded.

 

[Don Guillett]

Frank, and the rest of us, would benefit from a posting of your code.

--
Don Guillett
SalesAid Software
(e-mail address removed)

I've got MSQuery setup to retrieve data from an external database. I have

a macro that automatically refreshes the data when the file is open. It's
very cool because I've got it setup to prompt for the parameters (e.g.,
beginning date, ending date).

I'd like to complete the automation of this spreadsheet by telling Excel

to refresh all the pivot tables in this workbook, AFTER the data is DONE
being downloaded.

 

[Frank Kabel]

Hi Jonathan
as Don said please post the relvant part of your code
(otherwise all solutions provided are just a guess)

If you didn't receive an answer (which is quite uncommon)
problem is in most cases to not be specific enough. In
such cases just repost your question (stating this is a
repost) and try to re-state your issue

-----Original Message-----
I tried that last week and didn't get a single reply, so

I thought I'd be a little more direct.

Anyhow, will activeworkbook.refreshall wait until after

the data is DONE being downloaded? I tried this before
and it didn't seem to work.