Excel application not going away..

Programming and Web Development Forums - Microsoft OFFICE - Microsoft Office products

Skip to content

Excel application not going away..

Microsoft OFFICE
Post a reply

    Next

  • 1. Creating a CommadBar button?
    Hello, In which event is it most appropriate to create a CommandBar button that displays information about the currently open document? A little background on my Add In: VB6 COM add-in written to display and change a Custom Document Property for any Word document. Right now, I create my button on the IDTExtensibility2_OnConnection event, which essentially fires when Word is launched. I then update the caption of the button to display the custom document property on the following events raised for the Word Application object: DocumentChange DocumentOpen NewDocument I am noticing, however, that as users move through documents, in some cases, the reference to my button seems to go away, and when I try to set the button's caption property I get an "Object variable or with block not set" exception. What is the best practice for creating items in the CommandBar in Word for an addin whose items could change depending on the document that is opened? Should I recreated the button on DocumentChange??? That seems like a lot of overhead (and potentially "screen flickering") just to maintain a reference to the button... TIA!!! Brian
  • 2. Outlook 2003 task pane using VSTO?
    I am creating an addin that must work in Outlook 2003 and 2007. I want to create my own inspector basically. When my "task" is opened I want to see my .net created usercontrol. I have studied the PrepareMe addin sample that uses the custom Task pane. This seems like a viable solution (thought I want to change/mostly remove the existing form as well which I hope I can do with forms design). But It appears that this is only 2007 functionality. Although I read in Mr. Durant's blog from a couple years ago that it is indeed posible in 2003. The functionality I need in my inspector may be as simple as a browser control. Thanks!
  • 3. COM Shim Add-In for Project 2003
    So i had an add in that was managed and Shim-less, which was frowned upon by MSDN. So i went ahead and created a COM Shim for it, followed all the instructions to the T and installed on my own machine. It works great, much faster, but... It doesnt work on any other machine. It used to work as a managed add-in but now i cant get it to even start up. No errors, no warnings, nothing. I checked the GAC for the needed DLLs, office 11, MSProject and VBE Interop, all there. Registry, everything looks good, set to load with the application. Checked the Assembly Binding Log Viewer, on my machine everything loads and checks out, on any other, no activity is shown. Im going crazy, please help.
  • 4. My Addin's plug-in is not loaded in Word and Excel
    Hi, I am using VSTO 2005, OS XP and Office XP. My plug-in is loaded in Power-Point and Outlook but it is not loaded in word and Excel. Before loading the application its load behavior is 3 but after it become 2. So, my plug-in is not loaded. It is happen with Word and Excel only. Can any one have any idea on it? Mauleen
  • 5. My Addin is not plug-in in Word and Excel
    Hi, I am using VSTO 2005, OS XP and Office XP. My plug-in is loaded in Power-Point and Outlook but it is not loaded in word and Excel. Before loading the application its load behavior is 3 but after it become 2. So, my plug-in is not loaded. It is happen with Word and Excel only. Can any one have any idea on it? Mauleen

Excel application not going away..

Postby Somashekhar » Thu, 21 Aug 2003 07:24:56 GMT 

Hi,

I have an xll excel addin that makes some COM calls. I 
call OleInitialize and OleUninitialize for every COM/OLE 
call. But when Excel is exited, there is a process in task 
manager that still resides for long time. What's the 
reason for this ? Pls Suggest.
Top

RE: Excel application not going away..

Postby a-stculh » Thu, 21 Aug 2003 22:14:55 GMT 

Srini,
   What are you developing it in, VC6 or Dot NET.  And 
Do you have a small code snippet that reproduces the
problem.  If you comment out your COM calls does the
problem go away?  If so I'd peruse that avenue.  It sounds
a lot like references not being released at shutdown.



Stephen Culhane
 XXXX@XXXXX.COM 
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Content-Class: urn:content-classes:message
| From: "Somashekhar" < XXXX@XXXXX.COM >
| Sender: "Somashekhar" < XXXX@XXXXX.COM >
| Subject: Excel application not going away..
| Date: Tue, 19 Aug 2003 15:24:56 -0700
| Lines: 7
| Message-ID: <0df301c366a0$b7d2ec80$ XXXX@XXXXX.COM >
| MIME-Version: 1.0
| Content-Type: text/plain;
| 	charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNmoLfSzsYFrdj9Si2GjK3gMYe18Q==
| Newsgroups: microsoft.public.office.developer.com.add_ins
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl 
microsoft.public.office.developer.com.add_ins:4382
| NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| X-Tomcat-NG: microsoft.public.office.developer.com.add_ins
| 
| Hi,
| 
| I have an xll excel addin that makes some COM calls. I 
| call OleInitialize and OleUninitialize for every COM/OLE 
| call. But when Excel is exited, there is a process in task 
| manager that still resides for long time. What's the 
| reason for this ? Pls Suggest.
|
Top

Similar Threads:

1.Easy to reproduce (KB302901) Excel application not going away..

2.excel object not going away 

got a problem with an excel app object not ending even after closing all
workbooks and quitting the app ala objExl.quit.
excel.exe continues to run in task manager.
windows 2000 and excel 2002.

any clues?

thanks,
mcnews.

3.Instance of Excel will not go away 

My understanding is that when you create an Excel object, the correct way to 
cause the instance of Excel (in Task Manager Process) is to quit the 
application and set the object variable to Nothing.

You will not in my code below that I am doing that.  Note that this code is 
not attached to a form, yet. The instance of Excel will not go away until I 
close my Access database.  Could it be where I do the Select?  Is it 
necesssary to deselect it to get the instance to go away?

Here I open it:
    Set xlApp = New Excel.Application
    xlApp.DisplayAlerts = False
    xlApp.Interactive = False
    Set xlBook = xlApp.Workbooks.Open(varGetFileName)
    xlBook.Worksheets("Actuals_res_export").Activate
    ActiveSheet.Range("F3").Select
    Selection.End(xlDown).Select
    intLastRow = Selection.Row

code does stuff here

Here I close it:
    xlBook.Close
    Set xlBook = Nothing
    xlApp.Quit
    Set xlApp = Nothing
    rst.Close
    Set rst = Nothing
End Sub

4.Calculate at bottom of screen does not go away 

I am building a spreadsheet from scratch and when I add a formula and copy it 
down  the calculate appears on the bottom of the screen and does not go away. 
 It is not a circular reference.  I do have a pivot table and vlookups off of 
the pivot.  I am using formulas for 20,000 rows.  The vlookups casue it to 
calculate but it then goes away.  When I add the choose statement and copy it 
down to the 20,000 rows the calculate appears at the bottom and does not go 
away.

5.Count will not go away. 

I work with Excel 2003 and have noticed that when I extracta reports into 
Excel from another program and then save it, I am no longer able to highlight 
rows or columns of numerical date and get a total in the lowr right hand 
corner. I am now getting Count = and then the number of rows. How What do I 
have to change to be able to get my ability to see a total of the numerical 
date and not the count of rows?

6. word "calculate" will not go away

7. A LINE that will not go away

8. Headers that will not go away

Post a reply

Return to Microsoft OFFICE

 

Who is online

Users browsing this forum: No registered users and 10 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group