View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gcutter[_2_] gcutter[_2_] is offline
external usenet poster
 
Posts: 1
Default Auto Open file VBA Refresh MS Query Save Close


I have made a MS Query in Excel that queries a DB and puts the info int
excel. Is there code so that if I schedule the file to open the cod
will let the query to refresh and save and close the file?

Now we are having an employee open the file click enable auto refres
and save and close the file.

Thanks,
Greg
Impulse Manufacturin

--
gcutte
-----------------------------------------------------------------------
gcutter's Profile: http://www.excelforum.com/member.php...fo&userid=2751
View this thread: http://www.excelforum.com/showthread.php?threadid=47029