Running a saved query
Hello. I have a saved query for an excel sheet which I use to synchronize a
*local* copy of a worksheet with a *master* copy on the network. I have
saved this query on a network folder and want to make it possible for users
to hit a refresh button on their local worksheets and automatically refresh
all data with the latest data from the master sheet on the network using
this query. The problem is I have no idea how to run a saved microsoft query
from code using vba in excel. I am sure there is a way. I appreciate your
help.
Leo
|