LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External data query not being saved PatsFan Excel Discussion (Misc queries) 0 August 27th 07 06:10 PM
Help on Running Query jackle Excel Discussion (Misc queries) 5 January 25th 06 09:47 PM
Running Query Krish Excel Worksheet Functions 0 November 10th 05 07:42 PM
Getting External Data with Saved Query Festus Bola Ademorijimi Excel Discussion (Misc queries) 4 July 21st 05 06:08 PM
running a macro saved as a string jfp[_2_] Excel Programming 5 December 16th 03 08:45 PM


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"