ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Running a saved query (https://www.excelbanter.com/excel-programming/299647-running-saved-query.html)

Leo

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




All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com