backup

  1. V

    A complete backup macro

    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...
  2. R

    creating a hyperlink in a WS cell

    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...
  3. E

    VBA backup routine (save copy) with Excel 2010

    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...
  4. L

    Backup copy in a different location

    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...
  5. R

    Deleting old folder from a directory (backup)...

    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...
  6. FalconBLUE

    Backup Macro Codes...

    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...
  7. D

    Use current file path to indetify folder location

    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...
  8. D

    Save Copy As to a different folder

    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...
  9. Mississippi Girl

    Backup works for some users, not for others...

    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...
  10. R

    Check source folder for newly updated EXCEL files and make a copy in destination folder.

    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...
  11. R

    Macro to auto create backup workbook to another folder upon saving the original

    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...
  12. andrewb90

    Backup copy of workbook macro

    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...
  13. E

    Remove macro from backup excel document

    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...
  14. R

    Saving Spreadsheet causes Backup

    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...
  15. S

    How to make a backup sheet of original data?

    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
  16. S

    Convert backup file (.xlk) to original file (.xls)?

    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
  17. L

    export quick access toolbar

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

    Macro to save workbook and previous versions

    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...
  19. O

    Combine create new sheet and copy paste values only macros

    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...
  20. A

    auto archiving excel doc

    I am working on a multi-sheet workbook that captures data over a one year span. After the new year I would like a script that backs-up the current workbook, saving it with a specific file format, something like: "string cell reference"," ","old year". The tricky part is when it is finished...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top