1. T

    I am getting an error when I am attempting to close a backup file I created in my Save and Close Module

    I am wanting to create a backup file to my backup directory the close that file. I then want to save and the close the current workbook. Then close the Excel Application. I am having trouble closing the backup file and at the end closing Excel...
  2. M

    VBA Disabling 'Saving As' Popup

    How do I disable the popup that says Excel is "SAVING AS" with the bar that shows % complete? Application.DisplayAlerts = False doesn't seem to help. Application.DisplayAlerts = False ThisWorkbook.Save txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")...
  3. M

    Application Quit closing down all instances of Excel

    I've been fighting with application.quit for a while now because it wouldn't close excel. I had this in the open even and first check to see if the user had read write privileges to a folder they will need for everything to work. I got that squared away by putting and Exit Sub after the...
  4. W

    Focus on current wb for quit

    I wrote this to force exit without saving anything. Works fine if it is in the active workbook but when I move it to my Personal.xls it does not work. On the intended workbook. Any ideas? Sub Quit() Application.DisplayAlerts = False ThisWorkbook.Saved = True Application.Quit End Sub
  5. L

    How can I add an output option to my macro?

    How can I add a message pop up when the user clicks on my quit macro to display are you sure you want to quit the spreadsheet? With two options saying 'yes' and 'cancel'? Sub CloseButton() Application.Quit End Sub Thank you!
  6. P

    Application.Quit doesn't work

    Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) Dim sh As Worksheet Application.DisplayAlerts = False For Each sh In ThisWorkbook.Sheets Select Case sh.Name Case "Exhibit " & """I"" ", "page 2" Call...
  7. G

    Application.Quit doesnt terminate the Process

    Hello, i have following Problem: I wrote a Macro in Word, that opens an Excel file, changes stuff and saves ist again. When it runs a second time i get "method rows of object _global failed" as Error. (It works fine, if i close Word inbetween the runs). I suppose it's because the EXCEL:EXE *32...
  8. A

    Application.Quit Help

    Hi I’m writing an Outlook macro that looks in the incoming mails and, selects the specific mails, opens the attachments (only excel files), and copy the contents into another workbook, the process is really simple. Anyway after I close the workbooks, and the application, the Applications keeps...
  9. S

    workbook_open() not firing with application.quit

    I hope someone can help me with this one. Here goes. I am having a problem around the workbook_open event. First let me explain what I am trying to achieve. Basically, I want to start logging the execution of about 30 scheduled tasks which open various workbooks (which perform different...
  10. P

    Cannot quit Mircrosoft office Excel.

    Hi, This is my first post in Mr.Excel (Though i'm reading here from past a year). I've designed an excel application in which a userform will be active all the time showing on the desktop (somehow i managed to hide the excel application on the tastbar) Now when I try to Logoff / Shutdown...
  11. G

    Application.Quit does not work when ActiveWindow.Visible is False

    Here's a real head scratcher...Within the BeforeClose event, I call one of two procedures depending on whether the workbook is the only workbook in that particular instance of Excel. The first works fine. The second ends up working exactly like the first despite the use of Application.Quit...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back