Auto save, is it possible?

  • Thread starter Thread starter Tangy
  • Start date Start date
T

Tangy

Is it possible to have Excel autosave, say every minute or so. I'm not
referring to the auto recovers option.

Thanks
 
Thanks tried that one I get errors everytime it tries to save, I am using XP
03 maybe that why
 
Do you have any problems if you try to do a File / Save as yourself? If so
have you just updated Windows with Automatic updates at all?
 
I looked at that but don't understand how to do it. Help!! What the heck is
a Workbook code module?
 
You didn't answer Ken's question. There have been a few posts that a windows
patch was breaking the ability to save to a network drive (if I recall
correctly).

I think the solution for that was to uninstall that patch and reinstall it.
(Ken will correct me if I'm remembering incorrectly!)

If you're saving to a network location, I'd try this suggestion first.

If that isn't the problem, you may want to post more specific info about the
errors/messages you get with Jan Karel Pieterse's AutoSafe addin.

If there's a bug in Jan Karel's program (pretty unlikely!), I'm sure Jan Karel
would want to know.

If it's something else, maybe someone else can jump in with a solution.

====

But start a new workbook.

hit alt-f11 to see the VBE (where macros live)
hit ctrl-r to see the project explorer--a lot like windows explorer.

Find your workbook's name and select it.
hit the asterisk on the numeric keypad to expand all the "components" of the
project.

Look for ThisWorkbook and double click on it.
This is where the the workbook_beforeclose and workbook_open procedure would go.

Then click on Insert|Module (from the menubar inside the VBE)
That's where the AutoSave procedure would go.

Now hit alt-f11 to get back to excel
File|SaveAs
choose "Microsoft Office Excel Add-In (*.xla)" in the "save as type" box.
Give it a nice name.

Then tools|addins
and point at the addin you just saved.

But I think that this last portion is too much work. I'd find out why you had
trouble with Jan Karel's add.

==============
By the way, xl97 and xl2k had autosave built in. You may find it under
Tools|addins. (If it's not installed on your pc, you may need the distribution
CD to install it.)

And that addin works with xl2002+, too.

And one of the differences between xl's autosave and Jan Karel's AutoSafe is...

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.
 
Back
Top