Creating an Excel auto-save backup task

Posted by Unknown Senin, 19 Agustus 2013 0 komentar
Ever pressed Cancel or No when prompted to save an Excel spreadsheet?  Lost your work?  How about this backup task... it basically copies Excel backup files to another location so that Excel can't delete them when it closes.

  1. Open Task Scheduler (tap Windows Key; start typing "task scheduler", press enter/click on it when result is at top of Start Menu).
  2. Click Action - Create Basic Task
  3. Give it a name and click Next
  4. Select "When I log on" as the Trigger
  5. Select "Start a Program" and click Next
  6. Type "Powershell" in the Program Name, then
  7. in the "Add arguments (optional):" box, type "% {Copy-Item -path C:\Users\username\AppData\Roaming\Microsoft\Excel\ -recurse -force -destination D:\Backup\ExcelAutosave}" (changing the username to your username obviously, and also modify the destination directory if you want), then click Next
  8. Then tick the box "Open the Properties dialog for this task when I click Finish", then click Finish.
  9. Under the "Triggers" tab, double click the "At log on" trigger, then tick the box "Repeat task every:" select an interval (i have 1 hour) and duration (i have 12 hours), make sure "Enabled" is selected, then click OK, then OK on the properties box.
via
microsoft office - Recovering Excel documents that were closed without saving - Super User

The path on Windows XP is something like:
C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel
TERIMA KASIH ATAS KUNJUNGAN SAUDARA
Judul: Creating an Excel auto-save backup task
Ditulis oleh Unknown
Rating Blog 5 dari 5
Semoga artikel ini bermanfaat bagi saudara. Jika ingin mengutip, baik itu sebagian atau keseluruhan dari isi artikel ini harap menyertakan link dofollow ke https://androidtv7.blogspot.com/2013/08/creating-excel-auto-save-backup-task.html. Terima kasih sudah singgah membaca artikel ini.

0 komentar:

Posting Komentar

Trik SEO Terbaru support Online Shop Baju Wanita - Original design by Bamz | Copyright of android tv.