Results 1 to 3 of 3

Thread: CreateObject(Excel.Application) - Close it w/o Are you sure? msgbox

  1. Jun 12th, 2002, 03:25 AM #1
    SLH
    SLH is offline

    Thread Starter
    Not NoteMe SLH's Avatar
    Join Date
    Mar 2002
    Location
    192.168.0.1 Preferred Animal: Penguin Reason for errors: Line#38
    Posts
    3,051

    CreateObject(Excel.Application) - Close it w/o Are you sure? msgbox

    I've created an excel application to do some calculations. How would i close it, repressing the 'Do you want to save changes?' msgbox it displays.

    I've tried XLApp.Quit
    Quotes:
    "I am getting better then you guys.." NoteMe, on his leet english skills.
    "And I am going to meat her again later on tonight." NoteMe
    "I think you should change your name to QuoteMe" Shaggy Hiker, regarding NoteMe
    "my sweet lord jesus. I've decided never to have breast implants" Tom Gibbons
    Have I helped you? Please Rate my posts.

    Reply With Quote Reply With Quote
  2. Jun 12th, 2002, 03:33 AM #2
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Code:
    ' hide Excel messages from appearing on the screen
' by using the displayalerts call
With XLApp
    .displayalerts = false  
    .workbooks(1).close
    .displayalerts  = true
    .quit
End With

Set XLApp = nothing

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details
    Reply With Quote Reply With Quote
  3. Jun 12th, 2002, 03:36 AM #3
    SLH
    SLH is offline

    Thread Starter
    Not NoteMe SLH's Avatar
    Join Date
    Mar 2002
    Location
    192.168.0.1 Preferred Animal: Penguin Reason for errors: Line#38
    Posts
    3,051
    Works great, thanks.
    Quotes:
    "I am getting better then you guys.." NoteMe, on his leet english skills.
    "And I am going to meat her again later on tonight." NoteMe
    "I think you should change your name to QuoteMe" Shaggy Hiker, regarding NoteMe
    "my sweet lord jesus. I've decided never to have breast implants" Tom Gibbons
    Have I helped you? Please Rate my posts.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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