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?

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?

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?
>