Auto save, is it possible?

[Tangy]

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

Thanks

[Chip Pearson]

Download Jan Karel Pieterse's AutoSafe from
http://www.oaltd.co.uk/MVP/Default.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tangy" <t a n g y@rogers.com> wrote in message
news:Cc-dnaiBAediZYXfRVn-1Q@rogers.com...
> Is it possible to have Excel autosave, say every minute or so.
> I'm not referring to the auto recovers option.
>
> Thanks
>

[Tangy]

Thanks tried that one I get errors everytime it tries to save, I am using XP
03 maybe that why


"Chip Pearson" <chip@cpearson.com> wrote in message
news:ujy5Z74FFHA.2824@tk2msftngp13.phx.gbl...
> Download Jan Karel Pieterse's AutoSafe from
> http://www.oaltd.co.uk/MVP/Default.htm .
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Tangy" <t a n g y@rogers.com> wrote in message
> news:Cc-dnaiBAediZYXfRVn-1Q@rogers.com...
>> Is it possible to have Excel autosave, say every minute or so. I'm not
>> referring to the auto recovers option.
>>
>> Thanks
>>
>
>

[Ken Wright]

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?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Tangy" <t a n g y@rogers.com> wrote in message
news:SqidnR2afdsRmYTfRVn-gQ@rogers.com...
> Thanks tried that one I get errors everytime it tries to save, I am using
XP
> 03 maybe that why
>
>
> "Chip Pearson" <chip@cpearson.com> wrote in message
> news:ujy5Z74FFHA.2824@tk2msftngp13.phx.gbl...
> > Download Jan Karel Pieterse's AutoSafe from
> > http://www.oaltd.co.uk/MVP/Default.htm .
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> > "Tangy" <t a n g y@rogers.com> wrote in message
> > news:Cc-dnaiBAediZYXfRVn-1Q@rogers.com...
> >> Is it possible to have Excel autosave, say every minute or so. I'm not
> >> referring to the auto recovers option.
> >>
> >> Thanks
> >>
> >
> >
>
>

[NewsMan]

try this,

http://www.tek-tips.com/faqs.cfm?fid=4060



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

[Tangy]

I looked at that but don't understand how to do it. Help!! What the heck is
a Workbook code module?


"NewsMan" <itguru@telus.net> wrote in message
news:caqSd.12930$0h.6785@clgrps13...
> try this,
>
> http://www.tek-tips.com/faqs.cfm?fid=4060
>
>
>
> Tangy wrote:
>> Is it possible to have Excel autosave, say every minute or so. I'm not
>> referring to the auto recovers option.
>>
>> Thanks

[Dave Peterson]

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.



Tangy wrote:
>
> I looked at that but don't understand how to do it. Help!! What the heck is
> a Workbook code module?
>
> "NewsMan" <itguru@telus.net> wrote in message
> news:caqSd.12930$0h.6785@clgrps13...
> > try this,
> >
> > http://www.tek-tips.com/faqs.cfm?fid=4060
> >
> >
> >
> > Tangy wrote:
> >> Is it possible to have Excel autosave, say every minute or so. I'm not
> >> referring to the auto recovers option.
> >>
> >> Thanks

--

Dave Peterson