backup

Hello! On this thread I got some tips on a code for a weekly backup: https://www.mrexcel.com/forum/excel-questions/1029101-complete-backup-macro.html?highlight=backup However, I would like to add the function that makes the macro delete old backup files if there are more than 10 old backup...

Hello! I am looking for a excel macro that automatically does a backup each week (if I am not using the file for more than a week it will automatically do a backup as soon as I start the file). The backup should be named the file name followed with the backup date and be placed in another...

Greetings, below is a snippet from some code that I am using to create a backup copy of a WS, I haven't included everything, just the first part that I believe will pertain to my question. I have been noodling and searching for this for a bit but I am not having much luck. You will notice...

Hey guys, I coded the following backup routine in VBA last month and just when I needed one of those (presumably working) backup files I noticed the error I made... Stupid rookie mistake I guess. Basically the code was intended to save a copy of the active workbook with a time/date stamp in a...

I'm using the following workbook code to frequently save a timed and dated copy of the file in a backup location elsewhere before saving the file at it's normal location. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim fn As String, ext As String, ipos As Long...

Hi there, I have had a script running to make a daily backup of files in a directory. The files are all bundled into a folder and saved into the backup directory (as a backup system) The files are all tiny, but I have noticed that my 'backup directory' is growing ever bigger and I only really...

Hi everyone, I want to backup my workbook with below codes. First of all, codes are checking backup folder whether or not. If not the folder, being created in C:\ and then being identified. Finally, this code must saveAs active workbook. But not. Where I am making mistake I don't know. Could...

Hi, I have this code that works fine for majority however the way people access the folder from different offices is causing an issue. Basically if I use the direct path as shown in the code, it doesn't work, so I wondered if there is a way for the code to identify current path and then place...

Hi, I've got this code that allows me to create a backup copy of my workbook however I can't find any code that I can include that will save the copy to defined folder location e.g. "G:\My Documents\Temp\AMP\Archive" I'm sure it's easy but I can't find anything that seems to work with this code...

We have a workbook that is shared by a lot of people. It's saved on a network drive and users of the workbook go in and make updates as needed. We've been having problems with folks forgetting to save their work, so I included this bit of code to save a "back up" before the file is closed...

Hi Could you please help me with the scenario below? My source folder is called "Source\Files\" It also has shortcuts folder that is shortcuts of the all original files say "Source\Shortcuts\". These shortcuts point to files in "Source\Files" folder. ---- I need to create a backup of this...

Hi, I haven't been able to figure out a macro that , upon saving my file, will automatically create a backup file (my original file name plus "backup" added to the end), and save it to my desktop. Outside of this macro, my assumption is that each time the backup is saved there will be a message...

Hello, I am using this code to create a backup copy of my workbook: Sub DOUGHMON()Dim fname fname = "C:\Users\Andrew\Desktop\WEEKLY SALES REPORTS\" & Format(Now, "dd mmm yy") & ".xlsm" ThisWorkbook.SaveAs Filename:=fname End Sub The only problem with this code is that my current file gets...

I have this macro currently running on an original excel document Which creates a backup of the document each time the document is opened; I was wondering, is it possible to remove that particular macro from the backup as opposed to saving the backup as .xlsx? I don't want to be able to open a...

Hi All, I'm working in Excel 2011 and I have peculiar problem. Whenever I make a change to any of my spreadsheets and click save, a backup is created in the same folder. I've checked the info field and made sure Stationary Pad was unchecked. I've also checked in preferences and unchecked...

How do I make a copy of a worksheet in excel as a backup in the same workbook before making modifications? Please help. I need the excel to do this automatically in the beginning so that when user starts modifications the original sheet is backup automatically. Thanks

Hi all, i accidentally deleted my original file, but i have a backup file of my excel workbook. Currently its filepath is blahblah.xlk. I wish to convert it back to .xls form to prevent any problems. Is that possible? Thanks excel 2003 Shie Boon

how can i backup [export] my QAT? where are the settings stored? excel 2010

Hi experts, I was looking for a macro to save a workbook, but also the previous generation. I searched this board and other internet sites but have not found the solution. I know how to save a workbook, but I was looking for the code to find the existence of previous versions ( the -1 and -2...

Hi Guys, I have two macros I want to combine in order to create new clean, value only backups within my workbook. I want to make a new sheet and name it with todays date. Then I want to go to ANY other sheet, copy all of it, and paste it to the new sheet with VALUES only. I have two macros...