Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Toolbar button (2000)

    Hi ,

    I am trying to create a button in a toolbar to exit MS Excel completely and not return back to MS Access
    as the spreadsheet is called from within MS Access.

    Is there a way of doing this?


    Justin.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Toolbar button (2000)

    You could copy the File | Exit menu item to the toolbar: select Tools | Customize..., activate the Commands tab, select File in the Categories list, then drag Exit from the Commands list to the toolbar. You can change the way the item is displayed by right-clicking it.

    I don't understand, though, what you mean by "exit MS Excel completely and not return back to MS Access". Why the "not"?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (2000)

    This is what l tried but it simply returned you back to the Access screen.

    The reason l say 'not' is that the user has finished user the program therefore there is no need to have it open.

    Justin.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Toolbar button (2000)

    You wrote that the Excel workbook is opened from Access. If the user won't need to return to Access, you should exit Access after opening the Excel workbook. I don't know how you open the workbook, but if you use VBA code in Access, you can use Application.Quit to exit Access.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar button (2000)

    Thanks your assistance l will use the method you suggested.

    Regards
    Justin

Posting Permissions

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