Results 1 to 5 of 5

Thread: Closing Excel

  1. Nov 24th, 2000, 09:20 AM #1
    gerard
    gerard is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2000
    Location
    Australia
    Posts
    69

    Unhappy

    Hi guys!

    Is there a nice way of closing a open excel 97 application down. I want to have a button within a spreadsheet that allows the users to close and quit the excel applications, without the need to go to file ...exit.

    ta


    Gerard
    Live long and prosper...
    Reply With Quote Reply With Quote
  2. Nov 24th, 2000, 09:55 AM #2
    faisalkm
    faisalkm is offline
    Fanatic Member faisalkm's Avatar
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    752

    Wink This works

    Hey May be this will help u

    Open Excel
    Select Toolbars->Forms
    Add a button to the sheet
    Select new to write code
    use this code
    Excel.Application.ActiveWorkbook.Save
    Excel.Application.Quit

    Try it!!!


    Faisal
    Faisal Muhammed
    Homepage:I Started making it in 1994 ...Still Under Construction
    Using

    Visual Basic 6.0 Enterprise SP5
    Embedded Visual Basic 3.0
    SQL Server 2000
    Windows 2000 Proff
    Delphi 6.0


    Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
    Reply With Quote Reply With Quote
  3. Nov 24th, 2000, 10:09 AM #3
    tumblingdown
    tumblingdown is offline
    Hyperactive Member tumblingdown's Avatar
    Join Date
    Mar 2000
    Posts
    362
    Press the switch with the word Power written on it, on the front of the computer.


    Hope this helps.


    td.
    "One logical slip and an entire scientific edifice comes tumbling down." - Robert M. Pirsig


    [email protected]

    "but if Einstein is right and God is in the details, reality requires that we sometimes get religion." - Scott Meyers.
    Reply With Quote Reply With Quote
  4. Nov 24th, 2000, 10:15 AM #4
    gerard
    gerard is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2000
    Location
    Australia
    Posts
    69

    Talking

    Works judt fine!!!

    Thanks
    Live long and prosper...
    Reply With Quote Reply With Quote
  6. Nov 24th, 2000, 10:26 AM #5
    faisalkm
    faisalkm is offline
    Fanatic Member faisalkm's Avatar
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    752

    Talking

    Nice to hear my code works. Thanks..I feel like became a programmer
    Faisal Muhammed
    Homepage:I Started making it in 1994 ...Still Under Construction
    Using

    Visual Basic 6.0 Enterprise SP5
    Embedded Visual Basic 3.0
    SQL Server 2000
    Windows 2000 Proff
    Delphi 6.0


    Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
    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