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.