autosave file

I've created a tool to manage resources for disabled persons in a group home setting. It will be used by non-excel users mostly. I'm trying to create a macro that saves the existing file to a backup directory before exiting. Anyone have experience with this? I'm hitting my frustration point.

Hello Folks, I've developed a workbook to be used by employees with access to a certain folder. At the end of the month, a macro is run to reformat for a new month. I'd like to save the completed file to a new filename (which can then be protected), or save the old filename to another file...

Hi All, The premise I'm struggling with is to save excel attachments to folders on my PC automatically, but using a rule that looks for specific words in attachments, saves them to different folder locations. For example test in subject, in email 1, would send it to folder1. Then test2 in...

windows7, excel 2010 I have a workbook that' s always open and i want to make autosave it everyday on a scheduled time. I wrote the following code: Sub Autosave() Application.OnTime TimeValue("18:10:00"), "Autosave" ChDir "P:\Test" ActiveWorkbook.SaveAs Filename:=Format(Date, "ddmmyy") &...

I go into Options | Save and see that they are supposed to be auto-saved every 5 minutes to: AutoRecover File Location C:\Users\user2\AppData\Roaming\Microsoft\Excel\ But when I look in that directory, I dont see ANY saved files. Why not? What can I do to fix this?

Hello Guys, I have been using the following code for some time and is working perfect. Sub Rotation() ' ' Macro1 Macro ' Macro recorded 9/10/2009 by Ali ' ' Columns("AM:AU").Select Selection.EntireColumn.Hidden = False Range("AS8:AS39").Select Selection.ClearContents...

Hi, At the end of the excel file (Autosaved) eg: book1(Autosaved), what does that mean? My file is like 5 mb and it is very slow too, is that normal? what will happen if i uncheck the box in "save Auto recover infomration every [10] minutes"? (Path > excel options >> save > ...) Thanks, pedie;)