|
-
Aug 14th, 2000, 12:09 PM
#1
Thread Starter
Member
I've got an ActiveX dll that opens up Excel and starts a workbook, puts information into the workbook, closes the workbook and saves the workbook. ' wrkObj.Close (True) '
However, an instance of Excel remains open everytime. It's hidden but its on the task list and sucks up resources. There has to be a simple line of code that tells Excel to die already!
Any help would be appreciated
-Brad
-
Aug 14th, 2000, 12:20 PM
#2
Fanatic Member
Chemically Formulated As:
Dr. Nitro
-
Aug 14th, 2000, 04:01 PM
#3
Addicted Member
an App.Quit wouldn't hurt either.
-
Aug 15th, 2000, 05:56 PM
#4
Frenzied Member
I use the following when closing down my hidden copy of Excel:
XLApp.Workbooks(1).Close SaveChanges:=True 'close and save workbook
XLApp.Quit
Set XLApp = nothing
-
Aug 16th, 2000, 06:02 AM
#5
Lively Member
DIY
You could just close it yourself if you made it visible:
exApp.Visible = true
...and then you could just use the close button when you are finished with it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|