Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help on any part of this would be great
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=509286 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
How to use solver to schedule part time and full time workforce? | Excel Discussion (Misc queries) | |||
Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
Modification of Part Number (Revised) | Excel Discussion (Misc queries) | |||
Part Number/Qty Consolidations | Excel Discussion (Misc queries) |