VBA Autosave upon starting Excel

[Mette85]

Hello.

is it possible autorun this VBA code when i open a excel file?

Sub SaveThis()
Application.DisplayAlerts = False
ThisWorkbook.Save

Application.OnTime Now + TimeValue("00:30:00"), "SaveThis"
End Sub

 

[rollis13]

If you mean "when you open that file and the macro is in that file", then just add this to the ThisWorkbook vbe module:

Private Sub Workbook_Open()
    SaveThis
End Sub

but if you mean "when you open every file (whatever Excel file) that dosen't contain that macro", well not so simple, you could try to save a file (with both macros) in the XLStart folder. Then you would use ActiveWorkbook instead of ThisWorkbook, anyway it would still miss the first Save.

 

[Mette85]

i tryed it like this. the reason i want it to run the atuosave macro when they open the file is because i am using that macro on a Storage system that is running tablets.. so its hard to push the save button in excel since it`s so small :P and the tutchpen isnt that great.

so i am trying to remove the hassle with saving the dokument all the time :P

 

[Mette85]

i tryed it like this. the reason i want it to run the atuosave macro when they open the file is because i am using that macro on a Storage system that is running tablets.. so its hard to push the save button in excel since it`s so small :P and the tutchpen isnt that great.

so i am trying to remove the hassle with saving the dokument all the time :P

but it still does not autostart the autosave vba

 

[rollis13]

You did it the other way around, I had said that the macro Workbook_Open macro went into the ThisWorkbook module.

 

[Mette85]

You did it the other way around, I had said that the macro Workbook_Open macro went into the ThisWorkbook module.



so sorry about that... my fault.. was tired yesterday, and today :P but thank you soo much for that! anything i can help you with? :D

 

[rollis13]

Thanks for the positive feedback, glad having been of some help.
Oh yeah, you can help make me win at the lottery ?.

 

[Mette85]

Thanks for the positive feedback, glad having been of some help.
Oh yeah, you can help make me win at the lottery ?.


haha.. well.. i think maby one of the numbers will be 7 next time?:P