save and close

While the saving box appears there is a cancel button at the bottom right corner. I want to prevent this button from appearing or prevent the saving box to appear all together. Essentially I don't want the user to cancel the save process. Please see the screenshot. Thank you!

Hello, I am very new to VBA and I have a module to save a file with a static name and the current date. I want to be able to click the red x and run the module. Is there a way to do that? Currently I am using a shortcut to run the module but when I click the x I would like to activate the...

This is so painfully close to working - it needs a tiny tweek and I'm hoping a genius can help with the last little bit? I've got an index [named A3 Materials Requisition] that uses a Command Button to add the next number to an existing sequence [named IE79MR001, IE79MR002, etc]. It logs the...

I have a workbook "Test" with sheets "A", "B", "C" etc. I am looking to move each of these sheets and save them in the same location as workbook "Test" using a file name from a cell in the sheet. I am trying to use the following code for the above that I found in one of the MrExcel threads: It...

I have a macro-enabled workbook which is read-only (data is recorded on the workbook through the use of macros). I need it to automatically save when closed. The following code saves the workbook on closing but it doesn't save the data recorded by the macros. Private Sub...

I have the following code: Sub addwb() Application.ScreenUpdating = False Dim wbNew As Workbook Sheet1.Copy Set wbNew = ActiveWorkbook wbNew.SaveAs "C:\Users\Owner\Documents\Automation\TestWB.xlsx", 51 wbNew.Close True End Sub but I am prompted if...

Hello everyone, I have a macro that opens another excel file, makeschanges in that file and should then save and close the document. Currently I am using this line of code for saving and closing the document: WB2.Close SaveChanges:=True By using this code it is doing save as meaning it opens...

Hi Mr. Excel Friends, I want to have my workbook save and close certain times in the day. I have tried inputting this code in the "This Workbook" object: Sub Close_Workbook() Dim Wkb As Workbook If Time() = Time.Value("13:30:00") Then ThisWorkbook.Close SaveChanges:=True...

Hi all I’m looking for a vba-macro that will pop up a warning after 5 min inactivity and then save & close if still idle after 5 more min. Ideally the clock would restart after the pop up is close. Thanks in advance/ Office 2016 if it helps Cooky857

Hi all I’m looking for a vba-macro that will pop up a warning after 5 min inactivity and then save & close if still idle after 5 more min. Ideally the clock would restart after the pop up is close. Thanks in advance/ Office 2016 if it helps Cooky857

Hello In my code to export a query to Excel, I am trying to adapt the code from Titleist23 https://www.mrexcel.com/forum/excel-questions/584129-disable-access-excel-backup-file-vba.html to save and close the workbook and stops making a backup file. This is my code working fine to export a query...

Hi, I'm still new to VBA and can't figure this one out. I work with txt files that I open with Excel (2010 on Windows). I need to accomplish the following steps: 1. Save the workbook as xlsx file, to the same location where the txt file currently was. No name change is needed, just the file...

Hi All, I am new to excel Vba , Please help me with How to save the current excel file with today's date Minus one ? For example todays date is 11-11-12 i want to save file as 10-11-15 . And also i run three reports daily lets say i run A,B,C. A&B reports will run before 12 in night and C...

Hello All, I had an automated process that use to take all extracts from a system in ".XLS" format (A lot of quotes); however, the system I got them uploaded to is no longer accepting ".XLS" format, it only accepts ".XLSX" Format, the problem here is that IT does not want and will not invest...

Excel 2010 So I have some complex (to me) VBA code that I retrieved from here: http://www.mrexcel.com/forum/excel-questions/382343-visual-basic-applications-copy-specified-cells-all-files-folder.html from user Nirvana_. The code's purpose is to look through a directory of excel files, and...

I have daily repetive tasks that need a VBA to help me out. I have a file which is updated daily, the excel file contains like: First Name|Last Name|Email| Password John| Lee | Johnlee#hotmail.com | blabla ...... So here are my tasks, when a client ask for like 100 accounts, I cut 100 accounts...

Can anyone tell me the best way to do suppress all warnings when saving a file programatically? I'd like to suppress all warning dialogs. I've set "application.displayalerts" to false, but I've got a dialog that still pops up which halts code execution. The nature of this program is that it...

Hello Everyone. I hope someone will be able to assist me with this issue. Each time I open my Ms Excel Workbook it shows the sheet it was on before it was closed. What I want to do is, on the click of a button, it will do three things: 1. save the file. 2. Return to a main page 3. Close the...

Hi All, I need a formula in excel to save a value in a cell A1, copy it from cell B1, but the value in B1 is always changing.:( I need it to be fix in cell A1. Regards, Kai

Hi all, I am trying to close a workbook that I have just copied data from and I don’t want to receive the “do I want to close without saving” message. The section of code in question currently looks like this: ' Close customer workbook customerWorkbook.Activate...