Execute a query from a macro
 

Hi,
Have created a query in MS query that runs from a
macro. Want other users to be able to also run the
query. Problem is that the macro only executes the query
from the original location saved (on my local hard drive)
instead of server folder. How can I force the macro to
execute the copy on the server? TIA for any help.

Ken