Save As Keeping Original Open

Save a workbook as 'Save As' but Keeping the original workbook open

Good Evening Everyone I am stuck with this problem, and would appreciate some help. i need a code to save my workbook as 'Save As' and close ...

Save As Keeping Original Open - Excel Tips - MrExcel Publishing

Today's article is about the awesome VBA method for SaveAsCopy. This command will keep WorkbookA open and called WorkbookA. The macro can keep running. But it ...

Using VBA macro to SaveAs but keep original file open [duplicate]

I have read that people suggest the use of the "SaveAsCopy" function, however, I need to save it as an .XLXS and not an .XLSM file, which " ...

Keep main file open when doing Save As in excel - Super User

I didn't find a way to keep both files open at the same time. But you can use the code below to keep the original file open （But the saved ...

VBA - copy file as macro free and keep the original open - Mr. Excel

1. run the macro in currently opened xlsm file 2. save entire workbook (multiple sheets) as xlsx (macro-free), without opening xlsx - I don't want to see the ...

save button and keep original open - Excel Help Forum

I am trying to make a click button save a file based on the info in a cell, but it opens the saved file up and shuts down the original.

Save a copy before editing to prevent changing the original file

Todd's story about AutoSave and Save a Copy. Open the file you want to copy. Inga uses a monthly Excel budget report that she created to keep track of her ...

Save As, but Both New and Original Remain Open | VBA & Macros

Is there a way to alter this code so that BOTH original and new workbooks remain open? Option Explicit Sub SaveMeD2() 'Saves filename as value ...

Open A New Copy Of Your Excel Workbook (keep original) - YouTube

... save a new copy every time you open the workbook. For example, you may be recording sales into a new workbook each day. You can leave the ...

VBA to Save Copy Closes Original and Keeps Copy Open : r/excel

I want to run a macro on an open file that saves a copy with a unique file name, without closing the original or opening the saved copy.

How to Save an Excel File as a Copy: VBA SaveAsCopy - YouTube

... save a copy of the workbook while keeping the original open. This was exactly what I needed for my situation. I was able to write a macro ...

Save Copy Of Workbook & Keep Both Open - Excel General

I have read a few posts on how to use SaveAs and SaveCopyAs to save workbooks, but neither one leaves both Original and New Workbook open.

SaveAs: Keep original copy open? [Archive] - VBA Express Forum

I save a copy of the worksheet I am using w/ .SaveAs w/ a .txt file format. This approach closes the original and keeps the newly saved copy ...

Macro to keep original file open, not 'save as' file - Excel Forum

Howdy... I don't know VBA. I got the below code off the internet and modified it slightly and it works for renaming. It does a 'save as' and ...

Excel: Saving and Sharing Workbooks - GCFGlobal

Save As: You'll use this command to create a copy of a workbook while keeping the original. When you use Save As, you'll need to choose a different name and/or ...

Excel for Beginners - Save, Save As & Saving Different File Types

Excel for Beginners - Save, Save As & Saving Different File Types ... Excel beginner's tutorial: create your first spreadsheet in minutes.

Save and rename opened excel file - Help - UiPath Community Forum

However the problem is that my original file has been overriden. How can I retain the pre existing file? Also do you have an example workflow ...

keeping original workbook open when saving - ExcelBanter

hello, i work on a master workbook where a macro deletes rows from a worksheet. After deleteing the rows I want the resulting workbook to be saved.

How do i make it so that the auto save option on the top left is always ...

By default, do you mean when you create the new file? You have to save it first once on a cloud location, if a file is new, it won't be saved ...

Saving .XLS, Keep current format or save as .ODS - (View topic)

I needed to open it in Excel at school so I could use their printer. When I opened the .XLS file it was my (ORIGINAL) .ODS file. I came home and ...