Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automate open/update/close Excel
Is there a way to automate opening, updating a query (i.e. hit the
"!"), saving, and exiting Excel? I would prefer a cmd type script I can schedule to run during off hours, but I'm open to other suggestions. I have a spreadsheet we use to track metrics for bug reports. The spreadsheet was created using an ODBC data base query which can be easily updated by opening the spreadsheet and updating the query. I need a way to automate the update on a regular basis. The query takes 10+ minutes so I would like to do it at night instead of having to wait for the query every time I open it...not to mention I have others who use it and don't have the ODBC tool set available. I would guess the solution would be a combination of a cmd script along with an Excel macro. Can an Excel macro do a file exit (and save)? Thanks -rosen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to open, Update links, save and close workbooks | Excel Discussion (Misc queries) | |||
Open, update and convert 2007--2003 then close without any prompt | Excel Discussion (Misc queries) | |||
Open and Close a Workbook to Update Links | Excel Discussion (Misc queries) | |||
How to open a list of excel files and get update, then close it? | Excel Discussion (Misc queries) | |||
Automate open file, update links, run macro, close and save file | Excel Programming |