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" wrote:

Hi,

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