Results 1 to 2 of 2
2008-03-25, 04:15 #1
- Join Date
- Sep 2002
- Thanked 0 Times in 0 Posts
Autosave to Different File Path (2003 SP2)
I have a user who has her AutoRecover set to a filepath on the network drive. It apparently never works. Is there some way to force an autosave to a specific file location (no matter who the user is) and have it be a network drive instead of a local directory? We have multiple employees who use these specific workbooks and we would like to have them save every 10 minutes or so to specific filepath like the one below. The code has to travel with the workbooks so the various addins suggested when I did a seach would not work for this specific case. As always, all help is much appreciated!
P:Admin ServicesDepartmentBudget2008-09 BudgetGeneral DocumentsReOrgBackup
2008-03-25, 08:43 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Autosave to Different File Path (2003 SP2)
You can set the path using code, but I'm not sure that is a good idea - what if someone opens the workbook on a PC where the network path is not available? Moreover, the path is the same for *all* workbooks.
The instruction to set the autorecover path is
Application.AutoRecover.Path = "P:Admin ServicesDepartmentBudget2008-09 BudgetGeneral DocumentsReOrgBackup"