ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autosaves not for recovery (https://www.excelbanter.com/excel-discussion-misc-queries/203776-autosaves-not-recovery.html)

Bettie Claxton

Autosaves not for recovery
 
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?
--
Bettie

Peo Sjoblom[_2_]

Autosaves not for recovery
 
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

"Bettie Claxton" wrote in message
...
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?
--
Bettie




Dave Peterson

Autosaves not for recovery
 
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 wrote:

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?
--
Bettie


--

Dave Peterson

Bettie Claxton

Autosaves not for recovery
 
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


"Peo Sjoblom" wrote:

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

"Bettie Claxton" wrote in message
...
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?
--
Bettie





Bettie Claxton

Autosaves not for recovery
 
Thanks, I'll try it and let you know.
--
Bettie


"Dave Peterson" wrote:

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 wrote:

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?
--
Bettie


--

Dave Peterson


Bettie Claxton

Autosaves not for recovery
 
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


"Dave Peterson" wrote:

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 wrote:

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?
--
Bettie


--

Dave Peterson


Dave Peterson

Autosaves not for recovery
 
Thanks for posting back with your results.

Bettie Claxton wrote:

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

"Dave Peterson" wrote:

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 wrote:

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?
--
Bettie


--

Dave Peterson


--

Dave Peterson

Bettie Claxton

Autosaves not for recovery
 
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.
--
Bettie


"Dave Peterson" wrote:

Thanks for posting back with your results.

Bettie Claxton wrote:

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

"Dave Peterson" wrote:

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 wrote:

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?
--
Bettie

--

Dave Peterson


--

Dave Peterson



All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com