Auto-Save

Nomis_Eswod

Board Regular
Joined
Jul 27, 2005
Messages
153
Hi,

I have a workbook, and Auto-Save added as an add-in. But, the workbook is to be used by people who potentially won't have that add-in. Is there anyway to write some code so that the sheet auto-saves every 5 minutes??

Many thanks in advance.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Code:
Option Explicit

Sub Auto_Save_Timer()
Application.OnTime Now + TimeValue("00:05:00"), "Auto_Save"
End Sub
Sub Auto_Save()
ThisWorkbook.Save
Auto_Save_Timer
End Sub

Of course, this will be negated if the user doesn't enable macros.

Best regards,
 
Upvote 0
You can write an On Open Event that checks for the add-in and if not found, installs it. Unfortunately, the machine I'm on now doesn't have Excel, so I can't check the nomenclature for you now, but it is something like

If Application.AddIns("Auto Save").Installed = False Then
Application.AddIns("Auto Save").Installed = True

Perhaps someone else can check it out, or see the vba help files

lenze
 
Upvote 0
Many thanks for this.

once I have started this, will it just continue to run?? I.e. if I put it in Workbook open will it then just continue to run??
 
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,085
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top