View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leo Leo is offline
external usenet poster
 
Posts: 4
Default 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