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