Results 1 to 3 of 3

Thread: Kill Excel

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jan 2004
    Location
    North east UK
    Posts
    129

    Question Kill Excel

    Hi All,

    can anyone tell me if it is possible to call a function from VBA that will kill all open occurences of Excel. I have an app that opens Excel and outputs data, however I am being left with the odd open excel process in the task manager even after Excel has been closed.

    I would like to add something that looks for open Excel processes and kills them all.

    Any help Appreciated.

  2. #2
    Addicted Member
    Join Date
    Aug 2002
    Location
    Luton, UK
    Posts
    178
    In the absence of another reply .....
    Rather than "bootstrap" a badly behaved application it would be better to change the code so that it closes down correctly.

    I am not an expert with this, but have seen plenty of information on the internet about closing applications opened using code. The application is closed by using 'Quit' and the object variables removed from memory by setting them '= Nothing' in reverse order to their creation.
    Regards
    BrianB
    -------------------------------

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Jan 2004
    Location
    North east UK
    Posts
    129
    Many thanks for your reply Brian, I should have closed this thread as I managed to resolve the issue.

    The issue was not actually with closing the Excel App but rather with closing all open objects.

    thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width