Skip to main content

Macro for Auto Back Up the excel file 

Sub Auto_Save()

Dim savedate

savedate = Date

Dim savetime
savetime = Time
Dim formattime As String
formattime = Format(savetime, "hh.MM.ss")
Dim formatdate As String
formatdate = Format(savedate, "DD - MM - YYYY")

Application.DisplayAlerts = False

Dim backupfolder As String
backupfolder = "D:\Back Up\"
ActiveWorkbook.SaveCopyAs Filename:=backupfolder & formatdate & " " & formattime & " " & ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
MsgBox "Backup Run. Please Check at: " & backupfolder & " !"

End Sub
Labels:

Comments

Post a Comment

Popular posts from this blog

How to Calculate Detention of Vehicles considering the complex Date & Time in excel

Some times it is difficult to calculate some cases which deals with Date & Time and calculating the Detention charges is one of them. Please download the excel file (and do remember that it has been prepared on the basis the following basis.... which can be changed with the help of formulas) https://drive.google.com/file/d/0Bw1qNoQ8YzHZY3E5VVl1SUduWm8/view?usp=sharing
2 comments
Read more

Sai Sampurna Padhi - A Sweet Bubbly Girl fighting for her life at Cuttack

Hello Everyone, Today I want to share with you all about a girl named "Sai Sampurna Padhi" Some details of this girl: - Name                   : - Sai Sampurna Padhi Age                       : - 2.5 Years Residence           : - Bidanasi, Cuttack, Odisha Father's Name    : - Linku Padhi Mother's Name   : - Chandrika Mohapatra Father's Occupation    : - Auto Driver at Badambadi Bus Stand, Cuttack This girl is admitted to SCB Medical College because she is suffering from a very dangerous disease called "Blood Cancer" and as its at Stage-I doctors has prescribed to go for Bone Marrow transplant as soon as possible so that this can be cured. But the operation cost around 20-25 Lacks which they can't arrange. For the time being, every week she has need of blood, plasma, test & medicine which is less as it is a government ho...
Post a Comment
Read more

FAQs on Hydroponics

From last several weeks I was searching for this on web and now wanted to share it.. For those who do not know about "Hydroponics" , Let me tell you that this is an alternative to our conventional method of Farming.  Hydroponics in simple words is "the process of growing plants in sand, gravel, or liquid, with added nutrients but without soil." Why we need it because the urbanization is growing rapidly and the agriculture land along with manpower & labour is going down and rarely available. We have now to focus on some alternatives for our food. Here are the FAQ List which will help. What is Hydroponics? Hydroponics is the method of growing plants using a soilless media which could include a wide variety of examples like: gravel, peat, vermiculite Perlite, old rubber tires, rockwool, and expanded clay aggregates. The minerals that the plant needs are dissolved into the water which is then watered directly to the plants. So, in short instead of the pl...
Post a Comment
Read more