Sub before and after 'Get External Data"

[kleysonr]

Hi,

Is it possible to run a sub before and after a process of 'Get External
Data' ?

 

[FSt1]

hi
not sure if i understand you correctly but the "get external data" can be
set up to run before and after. assuming that the MS Query is allready set at
sheet1 A1...

sub runitnow()

call RunFirstSub

Sheets("sheet1").range("A1").Querytable.Refresh _
Backgroundquery:= False

Car RunSecondSub

end sub

is this what you want??
regards
FSt1

 

[kleysonr]

This one can be a solution.

But what i want is:

I configured excel to get external data in a Access Database. So, before
Excel run the QueryTable.Refresh i need that it run a sub, and after the
QueryTable.Refresh process end i need run another sub. Like events
QueryTable.Refresh.Before or QueryTable.Refresh.After.

 

[FSt1]

hi
to my knowlege, there isn't a before refresh event or after refresh event.
i have a number of macros that manipulate data after the refresh and i
always just incorperated the refresh and manipulation into 1 macro.
in your example the before refresh macro would be triggered when you
refresh, then the refresh and the after refresh macro would be triggered
after the refresh was complete almost as if it was one macro like the example
i posted.
do you need to pause the macro at some point?

Regards
FSt1