Question: What is the proper code to input in the module/button that will specifically prompt the user to SaveAs , Close the (.xlsm) file, and open

What is the proper code to input in the module/button that will specifically prompt the user to "SaveAs", "Close" the (.xlsm) file, and open the same "New" sheet again?

I want to create an excel micro-enabled file .xlsm that will have a button called, "Save&New". The module/button will SaveAs, close the current file and open the same file again. For instance, when I'm filling out an audit and using the .xlsm sheet, I want to click the "Save&New" button for it to SaveAs, close it, and open the same file again but not the one I saved. Look at it has a template; only that I want the button to SaveAs, close the file, and open a "new" fresh file automatically.

Here is what I have so far:

In this image you see that I created the button called, "Save&New".

What is the proper code to input in the module/button that will

When I click on the "Save&New", it will "SaveAs" the .xlsm sheet.

specifically prompt the user to "SaveAs", "Close" the (.xlsm) file, and open

This is where I need help. After saving the sheet, I want the workbook to "Close" the file.

the same "New" sheet again? I want to create an excel micro-enabled

And open the same sheet before to work on a "New" audit workbook form (.xlsm). (Not the sheet that was saved, but the sheet open before modifying it)

file .xlsm that will have a button called, "Save&New". The module/button will

This is the code that I have inside the module/button called, "Save&New":

SaveAs, close the current file and open the same file again. For

The code currently "SaveAs" and it opens a "New" sheet of the same one that was used before saving it. The problem is that it doesn't close the workbook that was saved before, although it does open the "New" sheet.

Specifically, my question is:

What am I missing in my code that doesn't "Close" the workbook (.xlsm) after saving it?

System Audit Forl Insert Page Layout Formulas Data Review view Developer Team Tell me what wou want to do File Home cut wrap Text Normal Bad Calib E Copy BI u A E EE E Merge & C E Conditional Format as Good Paste Neutral Format Painte Formatting Table A4 Mio Inspector 3 /28/2017 Site Name Address N/A N/A Save&Nev a Type here to search insert Delete Form omments 2 AutoSum Clear. Soft nd & Filter Seloct 5/9/20 Share

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!