Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a different application from Excel
Is it possible to open a differnt application form Excel?
I have a spreadsheet that imports data from an Access database. This database needs to be refreshed before importing daqta so the spreadsheet is current. I'd like to be able to do this with one button click which opens the database, runs the auto_exec macro, and closes the database. Just to make it interesting, but database is in a different drive & directory. Is this possible? How so? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a different application from Excel
You can use "shell" to open a different application, but because you are
wanting to open an Access database there are a couple of questions. (I don't recomend shell for what you are trying to do. How many people will have access to this button. You don't really want multiple people openeing the database at the same time. What does your Auto_exec macro in Access Do. Is it possible to have Excel Update the Databse without explicitly opening it up. You can control an Access Database from Excel. How long does it take to update the Access Database. You don't really want to keep updating the Database if it was just updated by someone else just a moment ago. "JonR" wrote: Is it possible to open a differnt application form Excel? I have a spreadsheet that imports data from an Access database. This database needs to be refreshed before importing daqta so the spreadsheet is current. I'd like to be able to do this with one button click which opens the database, runs the auto_exec macro, and closes the database. Just to make it interesting, but database is in a different drive & directory. Is this possible? How so? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opening from other application | Excel Discussion (Misc queries) | |||
Opening Excel 2007 application | Excel Discussion (Misc queries) | |||
My file is not opening within my excel application? | Excel Discussion (Misc queries) | |||
Opening Excel Application difficulty | Excel Discussion (Misc queries) | |||
Slow-Opening Excel Application | Excel Programming |