Results 1 to 3 of 3

Thread: Auto save

  1. #1

    Auto save



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is there anyway to have my auto save that I created to have a time delay say like 5 minutes. We enter data in several spots and how I have it set up it takes to long to enter. I attached a image of my code, sorry its a picture but didnt feel like typing it all out on my phone.

    Sent from my SCH-R950 using Tapatalk 2
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	uploadfromtaptalk1362059132648.jpg 
Views:	71 
Size:	28.5 KB 
ID:	1173  

  2. #2
    Here is a different macro that I am trying out, I don't remember exactly where I found it at, so sorry can't give credit. What I would like it to do is start saving when workbook opens then after the workbook closes I would like it to stop.
    Any help would be greatly appreciated.



    'Macro that saves every 45 minutes

    'This is in a Module

    Sub SaveTruck()
    ThisWorkbook.Save
    Application.OnTime Now + TimeSerial(0, 45, 0), "SaveTruck"
    End Sub


    'This is in ThisWorkbook
    ' Starts the auto save

    Private Sub Workbook_Open()
    SaveTruck
    End Sub

    Sent from my SCH-R950 using Tapatalk 2

  3. #3
    Solved, figured out a new way

    Sent from my SCH-R950 using Tapatalk 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •