Results 1 to 3 of 3

Thread: vba Excel

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2000
    Location
    Lost in the Mojave Desert
    Posts
    82
    does anyone know how to close the excel application from vba?
    Don't go away mad, just go away.

    Bam-Bam

  2. #2
    Fanatic Member VBKNIGHT's Avatar
    Join Date
    Oct 2000
    Location
    Port25
    Posts
    619
    try using "application.quit" it should work.

    vbaex
    jay-z

  3. #3
    Lively Member iataman's Avatar
    Join Date
    Jun 2000
    Location
    Turkey
    Posts
    71

    Arrow Exc.Quit

    You did not mention how you open it but i guess you are
    using:

    Private Exc as Excel.Application
    ...
    ...
    ...

    Set Exc = New Excel.Application
    Exc.Visible = True

    So to terminate it just use

    Exc.Quit

    (If you don't want any 'Do You Want to Save Your Changes
    Questions you can use 'Exc.DisplayAlerts =False ')

    Hope it helps..

    While YourAge<=40
    Live(YourLife)
    Wend

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