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.
Bookmarks