autosave

  1. T

    Autosave Macro when doc is not read only

    Hi there, I am somewhat new to macros but getting better each day, much thanks to this forum. I have been fighting a macro for a while so I thought I should ask. I would like a macro that autosaves the current workbook every 5 minutes without opening a dialog box or whatnot. Just as if they...
  2. J

    Excel 365 Version Saving

    Hi I would like to disable version saving in the current Excel product. This feature has caused me issues. For instance: If I want to open an Excel spreadsheet and work within it without altering the file, I do not want to have to search through versions/dates to find where I started to revert...
  3. T

    AutoSaveOn issue with Excel 2013 and 2016

    Sorry if this is in the wrong location, this is the first time I am posting on this forum. My issue is a regarding a "Compile Error: Method or data member not found" that happens when an excel file is opened by some users. These users have either excel 2013 or 2016 installed. The compile error...
  4. R

    VBA Macro record data + Auto saving multiple sheets into 1 every hour

    Hello, I have a few small things I need help with. So, I have 3 pc's each with a workbook; Station1, Station2 & Station3 and each work book has 2 sheets. Sheet 1 has 3 cells which can be edited by the user the rest of the sheet is protected. I have set up a macro linked to a command button...
  5. T

    Enabling autosave when starting Excel

    It can be enabled manually with tools - autosave and then clicking the appropriate radio buttons. But you have to remember to do it, and it lasts only until you quit Excel. Is there a way of having it turned on permanently, or of enabling it by using VBA? I tried recording a macro but it gave me...
  6. A

    Display live(ish) excel data in webpage

    Hi I have created some reports in excel and have various pivots and graphs that I can view/refresh. What I would ultimately like to do is have the contents of the excel page displayed via a web browser so this can be seen by people across the business with out them using the excel spreadsheet...
  7. L

    Excel 2016 - Missing Excel work with no explanation (no crash, etc.). WHAT HAPPENED?

    First, let me start by saying for thelast 10 years I have worked primarily in Excel. I have literally spentthousands of hours in Excel and never had anything like this happen before... Yesterday, I was working in Excel and had 3 files open. I was no longer using file A so I wanted to save and...
  8. D

    How to turn off an autosave macro once it's been started? - VBA

    I have a person that gave me their spreadsheet which they use for manufacturing production. At the start of a shift, the shift supervisor presses a "Start of Shift" button. They asked me to place an autosave macro in there so it backs up throughout the day. I put the following macro in: Sub...
  9. A

    worksheet reopening

    I am using the code at the end of this post to make the sheet autosave every x minutes. The autosave function works perfectly. The issue is if there is another excel file open at the time of close the autosave sheet reopens at the time it would have saved. There is another excel file that...
  10. E

    Macro for Autosaving excel file once a day to a different directory with name + date

    Hi, I'm looking for a macro code which autosaves excel file once a day while it's open. I have found a code which would suit me but doesn't always work, maybe somebody could help me ? Code: Option Explicit Private Sub Workbook_Open() AutoSave 'Start Autosaving End Sub Private Sub...
  11. R

    Save file x minutes after a value is entered

    Hi, I have created a spreadsheet for uses to record production testing results ad this forum has been essential in automating some of the task. But now if find that users are not saving the results. I know I can use the OnTime application to autosave the file but I only want this to kick in...
  12. B

    Autosave messes with my VBA solution

    With AutoSave ON: I must close the active workbook after saving as .xlsx Then, copy the active workbook again, Delete the unnecessary columns and SaveAs the .cvs Otherwise, AutoSave performs the deletion and Autofit on the original copied worksheet. This code works, but seems kind of...
  13. J

    Help with Autosave macro when multiple workbooks open

    Hi, i have the following code which works great with just the one open workbook. But it runs into problems if other excel workbooks are open Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnTime dTime, "autoSave", False End Sub Private Sub Workbook_Open() dTime = Now +...
  14. W

    VBA to end a autosave macro

    Hi! I have a macro (in a module) that saves the workbook. In the startup script i have another macro that loads this macro every 5 mins (This is a macro that "activates" every time i open that workbook) If I close this workbook, and continue to work in other workbooks, it will "open" it again...
  15. D

    Auto Save question

    hy i'm presently working in a code that takes a few minutes to run, can go easily to 20/30 minutes depending on what the user wants i already disable cancel key so the user may not stop the completion of the code but a potencial problem come to mind what if the user force a crash of excel...
  16. D

    how to use autosave in excel 2016

    Hi, Can anyone tell me how to use autosave with excel 2016. I have an excel file on my pc, and would like to autosave any changes back to the local file system where it lives (not the cloud, or onedrive) every 3 minutes. I need to distribute this file to several people, can I set it up so it...
  17. rjbinney

    VBA to Turn OFF 'AutoSave'

    I have a pretty hefty file with a macro that does a couple of "Save As" (for backup, mobile-friendly, etc.). The final step of the macro is to open up the original file, which is stored in OneDrive. In the last few weeks, when it opens the original file, it flips the AutoSave option to ON...
  18. szita2000

    Autosave button appears on Quick Access toolbar - messes it up.

    Hi All. Since this morning, AutoSave button automatically added to my quick access toolbar. This is just so inconvenient as I have been using the same shortcuts for 8+ years. Alt+2 = Special Paste, Alt+1 = Format painter and so on... Now excel decides to place this button to No1, and it is...
  19. T

    Detect AutoSave in Excel 2016?

    I have a couple of spreadsheets that run some validation code when the 'BeforeSave' event is triggered. With the new autosave functionality (saving the document to Sharepoint on a very frequent basis), this causes two problems; (a) the code errors out, because the save still happens with the...
  20. Z

    Autosave as PDF in specified folder at specified time with specified name

    Hello, I'm new to VBA and excel but I've been stuck trying to figure out how to do what I need. I have a single excel spreadsheet named ShipTask1 that stays open always. I need to auto save at 7am and 7pm every day in a certain folder with Date_Time_ShipTask1 as the name and in PDF format. I...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top