Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open after auto refresh(Query) | Excel Discussion (Misc queries) | |||
Auto Open, Refresh, Save, Close | Excel Discussion (Misc queries) | |||
save & close after web query refresh | Excel Discussion (Misc queries) | |||
I like to open a folder,auto print,save then close | Excel Programming | |||
Auto open 8 workbooks in different folders, then save on close... | Excel Programming |