Autosaves not for recovery

[Bettie Claxton]

Is there an add-in for Excel 2003 and 2007 that will set up a save back to
the same file name versus the recovery file that gets deleted when you closed
Excel. We had one for Excel 200 that did this. The reason for the need is
that we have a spreasheet that is updated automatically from the Internet. We
write it back to the disk every five minutes, so that people in all of our
offies can see the latest prices within a 5 minutes span. The Excel 200
add-in did this for us nicely. I want to move all to 2007, but I must have
some way to really save the file back to itself automatically. Does anyone
know of one?

 

[Peo Sjoblom]

Autosafe by Jan-Karel Pieterse, since you are using it commercially you
might want to donate something
if it fits the bill


http://www.jkp-ads.com/download.asp

--


Regards,


Peo Sjoblom

 

[Dave Peterson]

The autosave addin that worked for xl2k will work in xl2003.

And I bet that it still works in xl2007--but I haven't tested.

 

[Bettie Claxton]

I looked at autsafe and it will only save to another file name. We could
make that work but would have re-educate all if we go that route. Thanks for
the suggestions.

 

[Bettie Claxton]

Thanks, I'll try it and let you know.
--
Bettie

The autosave addin that worked for xl2k will work in xl2003.

And I bet that it still works in xl2007--but I haven't tested.

 

[Bettie Claxton]

I finally got a chance to test this and you are right. It works very well in
both Excel 2003 and Excel 2007. Thank you again.

 

[Dave Peterson]

Thanks for posting back with your results.

I finally got a chance to test this and you are right. It works very well in
both Excel 2003 and Excel 2007. Thank you again.

 

[Bettie Claxton]

I have to correct myself. I've learned through further testing that this
add-in works for 2007/2003 if you select to save only the current workbook.
It does not work if you say to save all workbooks. We have a user who has
multiple spreadsheets that are being updated from a data source and need to
be saved frequently. We figured out this workaround. He opens one
spreadsheet that is set it to save the current workbook only. Once an
automatic save has occurred, he opens the second spreadsheet and the autosave
function will work on that spreadsheet as well for several hours. When he
sees that the saving has stopped, he closes both spreadsheets and restarts
them one at a time.