Re: Autosave to a memory stick

Jan Karel Pieterse's AutoSafe is the way to go:

http://www.jkp-ads.com/Download.htm

It saves a copy into a holding directory, then removes those to the recycle
bin. I end up using the recycle bin as a one or two week archive.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:dvoaq21l9mit9h1v16gaeik99h75uj1oce@xxxxxxxxxx
gc

If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and
2003 as
there was in earlier versions.

Autorecovery from Tools>Options>Save is it. This is not the same as
Autosave
which made true incremental saves at intervals and alerted you before
saving.

Autorecovery just saves a temporary file which it deletes if Excel closes
normally without incident.

BTW.....Dave Peterson reports that he tried an earlier version of
Autosave.xla
in XL2002 and it seemed to work fine.

I have also tried the Autosave.XLA from XL97 on 2002 and 2003 and does the
job.

To download the 97 version go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

In addition to the above......Jan Karel Pieterse has an addin called
AutoSafe
which also doen't alert before saving.

It doesn't overwrite the existing workbook when it saves. It saves to a
user
selectable folder. And when it's done, it either deletes these backups
(or
puts them in the recycle bin). And the user can always restore the
backups
from the recycle bin.

http://www.jkp-ads.com/Download.htm

(look for AutoSafe.zip)


Gord Dibben MS Excel MVP

On Wed, 10 Jan 2007 05:54:01 -0800, gc <gc@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I have a backup utility that failed at the same time I had a hard drive
failure, resulting in a highly inconvenient loss of data.

I want to employ autosave as an alternative, writing to a memory stick,
instead of a shared drive, for speed. I can't seem to make it work. Has
anyone made this work?

Office 2003, Win XP Pro.

Thanks



.

Relevant Pages

  • Re: Recycle bin
    ... bin" the file is not physically changed in any way. ... happens is that the OS marks that file name entry as inaccessible to ... When you delete the file from the recycle bin the file name entry and ... If you restore them, that implies they are on the drive somewhere, though normally when restoring from the recycle bin they are placed in the original location from which they were deleted. ...
    (microsoft.public.windowsxp.general)
  • Re: waitrose free hire of bike trailers
    ... burn loads of petrol to do the same short trip. ... Doesn't your local council do a recycling collection (for paper, ... Some of our paper and almost all glass goes in the village recycle bin ...
    (uk.rec.cycling)
  • Re: "This is the funeral pyre for thought in America today."
    ... collection are fined if they do not collect and recycle everything ... The point of the telly piece was that those silly little green boxes - the ones that are supposed to receive two weeks' worth of paper, metal, glass and plastic all mixed in together - are not up to the job. ... The paper arriving at the plant is increasingly contaminated with beer cans, plastic milk bottles etc. - a tenfold increase in non-paper waste in two years, I think the manager said. ... The bin men wouldn't take the metal, the paper blew all over the verge, and I didn't like the idea of my booze consumption being on public display. ...
    (alt.usage.english)
  • Re: Recycle bin
    ... bin" the file is not physically changed in any way. ... happens is that the OS marks that file name entry as inaccessible to ... When you delete the file from the recycle bin the file name entry and ... operating system file handling system. ...
    (microsoft.public.windowsxp.general)