| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to close Access from Excel VBA
Hi,
I'm programming a macro in Excel and would like the code to first shut down MS Access if it is already open before proceeding throught the script. How can I close Access from Excel in that manner? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to close Access from Excel VBA
http://support.microsoft.com/kb/210518/en-us "How to Use the Quit Method to Quit Access from Another Program" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Steve P" wrote in message Hi, I'm programming a macro in Excel and would like the code to first shut down MS Access if it is already open before proceeding throught the script. How can I close Access from Excel in that manner? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to close Access from Excel VBA
Perfect...THANKS JIM!
"Jim Cone" wrote: http://support.microsoft.com/kb/210518/en-us "How to Use the Quit Method to Quit Access from Another Program" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Steve P" wrote in message Hi, I'm programming a macro in Excel and would like the code to first shut down MS Access if it is already open before proceeding throught the script. How can I close Access from Excel in that manner? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Close Excel tables from Access | Excel Discussion (Misc queries) | |||
| how do I close the connection from excel to access after refresh? | Excel Programming | |||
| Close Excel from Access | Excel Programming | |||
| Update Access Query save and close through Excel VBA | Excel Programming | |||
| Access.Application.Quit - opens Access again then won't close - He | Excel Programming | |||
![Steve P[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
