Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    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


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts