Auto Open, Refresh, Save, Close
 

Hi,

I am using excel to query an access database, what i need to do is as
follows:

1.) Automatically open the excel spreadsheet at a particular time
2.) Wait for the spreadsheet to finish refreshing
3.) Disable all queries and macros so that when the file is re-opened
the macros do not run again or the query reresh
4.) Save the current file with a filename from cell A1 to a destination
folder location from cell A2
5.) Close the file.

i found a link explaining how to save a file name as cell a1

http://www.mrexcel.com/tip040.shtml

Any help would be much appreciated.

Thanks,
James.


--
Jimmycooker
------------------------------------------------------------------------
Jimmycooker's Profile: http://www.excelforum.com/member.php...fo&userid=7547
View this thread: http://www.excelforum.com/showthread...hreadid=508907