LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Closing Excel Object

you have probably created a non-releasable reference to excel in your code
(which you don't show). You must use fully qualified references to all
objects so they can be released

Rather than use

ActiveSheet.Name = "ABC"

you would use xlApp.ActiveSheet.Name = "ABC"

as an example.

This assumes that at the end of your code you

set xlSheet = Nothing
xlbook.Close SaveChanges:=False
set xlBook = Nothing
xlApp.Quit
set xlApp = Nothing

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
I am accessing a Excel object from VB 6.0. To open the
object I use the following;
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets.Item(1)

My problem when I use the following code;
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
to close the object, the process is still runnig in the
background in the process list. What do I do to remove it
from the process list and actually close the object. I am
using windows 2000 OS.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing workbooks w/o closing Excel Barb in MD Excel Discussion (Misc queries) 3 February 15th 10 06:42 PM
2 Label Options - Forms Object vs Control Box Object Awrex Excel Discussion (Misc queries) 3 July 17th 09 07:10 PM
Object Variable Not Set Error on Selection object Jean Excel Worksheet Functions 3 July 24th 06 06:45 PM
help !!!!.. Excel object not closing No Name Excel Programming 0 January 6th 04 11:49 AM
Help on closing object properly Snedker[_2_] Excel Programming 4 December 26th 03 11:52 PM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"