auto save | VBA & Macros | Excel Forum • My Online Training Hub

auto save

rathanak

Member

Members

Forum Posts: 58

Member Since:
June 25, 2016

Offline

September 10, 2016 - 8:42 pm

Dear expert,

How can we write vba code into a workbook which has option and timeset. The user only open that workbook and choose which workbook want to be auto save (active workbook, all workbook, or a specific workbook) and input time interval to start auto save...left it open and it will save all data automatically?

Regards,

See Answer

Philip Treacy

Admin

Forum Posts: 109

Member Since:
October 5, 2010

Offline

September 13, 2016 - 9:12 am

Hi rathanak,

why don't you use the built in auto save features, rather than write VBA to do this?

Regards

Phil

rathanak

Member

Members

Forum Posts: 58

Member Since:
June 25, 2016

Offline

September 13, 2016 - 10:16 am

Hi Phil ,

could you give me guide to built in auto save features?

Regards,

Rathanak

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 403

Member Since:
November 8, 2013

Offline

September 13, 2016 - 1:38 pm

Hi Rathanak,

You can use one of Microsoft code samples:

Sub SaveAll() ' Store the Activeworkbook in a variable. Set aw = ActiveWorkbook For Each wb In Workbooks If wb.Path <> "" Then ' Save file if it has been saved ' previously wb.Save Else ' If not previously saved, activate and show the ' Save As dialog box. wb.Activate Application.Dialogs(xlDialogSaveAs).Show End If Next aw.Activate ' Activate the original Activeworkbook. End Sub

You can change the code to make it work as you want, but as Phil said, it's better if you use the built in save features. See the image below for Auto Save settings.