Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 23rd, 2005, 02:26 PM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 168
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel does not quit

Hi,

I have a problem when I automate Excel from Access
I have tried early and late bindning.
Everything goes fine but Excel remains in Windows Task Manager

My code is here

Sub OpenExcel()
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
' Show Excel Open file dialog
xlApp.Application.Dialogs(1).Show "C:\"
' Some code to process here
xlApp.Quit
Set xlApp = Nothing

End Sub

Any succestions?

-vemaju
ps. I have posted this question in Excel VBA forum too


__________________
-vemaju





Similar Threads
Thread Thread Starter Forum Replies Last Post
Form quit and Access debor19071 Access VBA 1 March 3rd, 2008 09:51 AM
Auto run quit not cleat anukagni Access 4 June 22nd, 2007 01:32 AM
Excel does not quit vemaju Excel VBA 4 February 22nd, 2005 06:40 AM
Word VBA "Before Appliction.quit Holger Hamburger Excel VBA 1 July 8th, 2004 06:16 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.