Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel 2003 autosave a changing file

I need to have Excel 2003 save a changing file automatically and
periodically. This was available as an add-in in earlier versions. This
capability is fundamental to unattended (lab) data collection. What to do?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2003 autosave a changing file

If you still have autosave.xla from a previous version of excel, it'll work with
xl2003.

Jan Karel Pieterse wrote an addin (works in any version) called AutoSafe (note
spelling).

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, not autosafeVBE.zip, for your purposes.)

LeProf wrote:

I need to have Excel 2003 save a changing file automatically and
periodically. This was available as an add-in in earlier versions. This
capability is fundamental to unattended (lab) data collection. What to do?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Excel 2003 autosave a changing file

LeProf

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

Autorecovery from ToolsOptionsSave 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, 17 Jan 2007 15:51:01 -0800, LeProf
wrote:

I need to have Excel 2003 save a changing file automatically and
periodically. This was available as an add-in in earlier versions. This
capability is fundamental to unattended (lab) data collection. What to do?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - When I open files, why are some file names blue? Formula One Excel Discussion (Misc queries) 2 August 17th 06 05:58 PM
Excel 2003 crashes when opening a file from one particular user [email protected] Excel Discussion (Misc queries) 0 May 17th 06 05:23 PM
Sharing read-write Excel 2003 files ttt8262 Excel Discussion (Misc queries) 0 April 1st 06 09:39 PM
Insert & link a graphic file in Excel 2003 -- updatable pictures! ODI Excel Discussion (Misc queries) 7 November 14th 05 03:36 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"