Inability to End Excel Process

[Henry Stockbridge]

Hi,

I am using Access 2003 to automate an Excel workbook, but after the
code completes Excel does not quit (at least it is still listed in
Task Manager --Processes.)

I have set a reference to the Excel 11.0 object library. I have
declared my Excel variables as...

Dim appExcel
Set appExcel = CreateObject("E xcel.applicatio n")

... opened the file...

appExcel.Workbo oks.Open ("c:\PhysicianU pdates\" & qdf.Name & ".xls")

... and clean up when done...

ActiveWorkbook. Save
appExcel.Active Workbook.Saved = True
appExcel.Quit

Set appExcel = Nothing
Set rst = Nothing
Set qdf = Nothing

Set db = Nothing

Any ideas why Excel will not truly quit? Any help you can lend would
be appreciated.

Henry

[RoyVidar]

"Henry Stockbridge" <hs***********@ hotmail.comwrot e in message
<11************ **********@s48g 2000cws.googleg roups.com>:

Hi,

I am using Access 2003 to automate an Excel workbook, but after the
code completes Excel does not quit (at least it is still listed in
Task Manager --Processes.)

I have set a reference to the Excel 11.0 object library. I have
declared my Excel variables as...

Dim appExcel
Set appExcel = CreateObject("E xcel.applicatio n")

.. opened the file...

appExcel.Workbo oks.Open ("c:\PhysicianU pdates\" & qdf.Name & ".xls")

.. and clean up when done...

ActiveWorkbook. Save
appExcel.Active Workbook.Saved = True
appExcel.Quit

Set appExcel = Nothing
Set rst = Nothing
Set qdf = Nothing

Set db = Nothing

Any ideas why Excel will not truly quit? Any help you can lend would
be appreciated.

Henry

You are using unqualified references to Excel objects.

ActiveWorkbook. Save needs to be

appExcel.Active Workbook.Save

I'm more in favour of using a separate worbkook object

dim wr as object ' or Excel.Workbook
set wr = appExcel.Workbo oks.Open("c:\Ph ysicianUpdates\ " & qdf.Name &
".xls")

' do important stuff

wr.save
DoEvents
set wr = nothing
appExcel.Quit
set appExcel = nothing

BTW - you say you have set reference, but you declare your appExcel
as variant - for early binding

dim appExcel as Excel.Applicati on

--
Roy-Vidar

[Henry Stockbridge]

On Feb 15, 3:51 pm, RoyVidar <roy_vidarNOS.. [e-mail] :

"Henry Stockbridge" <hstockbrid...@ hotmail.comwrot e in message

<1171573235.953 818.177...@s48g 2000cws.googleg roups.com>:

Hi,

I am using Access 2003 to automate an Excel workbook, but after the
code completes Excel does not quit (at least it is still listed in
Task Manager --Processes.)

I have set a reference to the Excel 11.0 object library. I have
declared my Excel variables as...

Dim appExcel
Set appExcel = CreateObject("E xcel.applicatio n")

.. opened the file...

appExcel.Workbo oks.Open ("c:\PhysicianU pdates\" & qdf.Name & ".xls")

.. and clean up when done...

ActiveWorkbook. Save
appExcel.Active Workbook.Saved = True
appExcel.Quit

Set appExcel = Nothing
Set rst = Nothing
Set qdf = Nothing

Set db = Nothing

Any ideas why Excel will not truly quit? Any help you can lend would
be appreciated.

Henry

You are using unqualified references to Excel objects.

ActiveWorkbook. Save needs to be

appExcel.Active Workbook.Save

I'm more in favour of using a separate worbkook object

dim wr as object ' or Excel.Workbook
set wr = appExcel.Workbo oks.Open("c:\Ph ysicianUpdates\ " & qdf.Name &
".xls")

' do important stuff

wr.save
DoEvents
set wr = nothing
appExcel.Quit
set appExcel = nothing

BTW - you say you have set reference, but you declare your appExcel
as variant - for early binding

dim appExcel as Excel.Applicati on

--
Roy-Vidar- Hide quoted text -

- Show quoted text -

Thanks, Roy. Unfortunately, it wasn't successful. The code is hooked
to the click event of a control on a form. If I close the database,
the Excel process ends. If the code were put into an independent
module instead on the click event of a control, might that solve the
problem?

Henry

[RoyVidar]

"Henry Stockbridge" <hs***********@ hotmail.comwrot e in message
<11************ *********@j27g2 000cwj.googlegr oups.com>:

On Feb 15, 3:51 pm, RoyVidar <roy_vidarNOS.. [e-mail] :

>"Henry Stockbridge" <hstockbrid...@ hotmail.comwrot e in message

<1171573235.95 3818.177...@s48 g2000cws.google groups.com>:

>>Hi,

>>I am using Access 2003 to automate an Excel workbook, but after the
code completes Excel does not quit (at least it is still listed in
Task Manager --Processes.)

>>I have set a reference to the Excel 11.0 object library. I have
declared my Excel variables as...

>>Dim appExcel
Set appExcel = CreateObject("E xcel.applicatio n")
.. opened the file...

>>appExcel.Work books.Open ("c:\PhysicianU pdates\" & qdf.Name &
".xls") .. and clean up when done...

>>ActiveWorkboo k.Save
appExcel.Acti veWorkbook.Save d = True
appExcel.Qu it

>>Set appExcel = Nothing
Set rst = Nothing
Set qdf = Nothing

>>Set db = Nothing

>>Any ideas why Excel will not truly quit? Any help you can lend
would be appreciated.

>>Henry

You are using unqualified references to Excel objects.

ActiveWorkbook .Save needs to be

appExcel.Activ eWorkbook.Save

I'm more in favour of using a separate worbkook object

dim wr as object ' or Excel.Workbook
set wr = appExcel.Workbo oks.Open("c:\Ph ysicianUpdates\ " & qdf.Name &
".xls")

' do important stuff

wr.save
DoEvents
set wr = nothing
appExcel.Qui t
set appExcel = nothing

BTW - you say you have set reference, but you declare your appExcel
as variant - for early binding

dim appExcel as Excel.Applicati on

--
Roy-Vidar- Hide quoted text -

- Show quoted text -

Thanks, Roy. Unfortunately, it wasn't successful. The code is
hooked to the click event of a control on a form. If I close the
database, the Excel process ends. If the code were put into an
independent module instead on the click event of a control, might
that solve the problem?

Henry

If this wasn't successfull, then I think it is possible that you use
more unqualified referencing in the rest of your code, that needs to
be amended. But to be of assistance, we would need a bit more than
"Unfortunat ely, it wasn't successfull".

I don't think there would be any difference whether this resides in
a separate module vs within a forms module, the code needs to be
without any implicit referencing of Excel objects, properties and
methods.

Here's one Microsoft KB article with some information on what I think
is the problem
http://support.microsoft.com/default.aspx?kbid=178510

--
Roy-Vidar

[Henry Stockbridge]

On Feb 16, 2:42 am, RoyVidar <roy_vidarNOS.. [e-mail] :

"Henry Stockbridge" <hstockbrid...@ hotmail.comwrot e in message

<1171580317.533 874.99...@j27g2 000cwj.googlegr oups.com>:

On Feb 15, 3:51 pm, RoyVidar <roy_vidarNOS.. [e-mail] :

"Henry Stockbridge" <hstockbrid...@ hotmail.comwrot e in message

<1171573235.953 818.177...@s48g 2000cws.googleg roups.com>:

>Hi,

>I am using Access 2003 to automate an Excel workbook, but after the
code completes Excel does not quit (at least it is still listed in
Task Manager --Processes.)

>I have set a reference to the Excel 11.0 object library. I have
declared my Excel variables as...

>Dim appExcel
Set appExcel = CreateObject("E xcel.applicatio n")
.. opened the file...

>appExcel.Workb ooks.Open ("c:\PhysicianU pdates\" & qdf.Name &
".xls") .. and clean up when done...

>ActiveWorkbook .Save
appExcel.Activ eWorkbook.Saved = True
appExcel.Qui t

>Set appExcel = Nothing
Set rst = Nothing
Set qdf = Nothing

>Set db = Nothing

>Any ideas why Excel will not truly quit? Any help you can lend
would be appreciated.

>Henry

You are using unqualified references to Excel objects.

ActiveWorkbook. Save needs to be

appExcel.Active Workbook.Save

I'm more in favour of using a separate worbkook object

dim wr as object ' or Excel.Workbook
set wr = appExcel.Workbo oks.Open("c:\Ph ysicianUpdates\ " & qdf.Name &
".xls")

' do important stuff

wr.save
DoEvents
set wr = nothing
appExcel.Quit
set appExcel = nothing

BTW - you say you have set reference, but you declare your appExcel
as variant - for early binding

dim appExcel as Excel.Applicati on

--
Roy-Vidar- Hide quoted text -

- Show quoted text -

Thanks, Roy. Unfortunately, it wasn't successful. The code is
hooked to the click event of a control on a form. If I close the
database, the Excel process ends. If the code were put into an
independent module instead on the click event of a control, might
that solve the problem?

Henry

If this wasn't successfull, then I think it is possible that you use
more unqualified referencing in the rest of your code, that needs to
be amended. But to be of assistance, we would need a bit more than
"Unfortunat ely, it wasn't successfull".

I don't think there would be any difference whether this resides in
a separate module vs within a forms module, the code needs to be
without any implicit referencing of Excel objects, properties and
methods.

Here's one Microsoft KB article with some information on what I think
is the problemhttp://support.microso ft.com/default.aspx?kb id=178510

--
Roy-Vidar- Hide quoted text -

- Show quoted text -

Many thanks for the help. I qualified my range and cell objects and
now everything works like a charm.

Henry