Autosaving Workbook

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

I have a shared workbook that needs to be saved about every 5 to 10 minutes,
as well as when the workbook is opend and closed. Using the Autosave add in
would be perfect and the OnOpen OnClose woudl be good for closing. My
question is this - If the autosave add in is on the computer, and multiple
people logon to the computer, will the add in be present with each persons
profile since it is part of Excel? If not, does anyone have any suggestions
on how to achieve this using somthing like the Time = X, OnTime + 10
Autosave.Activeworkbook, OnTime + 20 Autosave.Activeworkbook, Ect. Thaks in
advance!!!

ZABU
 
Hi,

Thank you for posting in MSDN managed newsgroup!

From my understanding to this issue, you want to know whether the autosave add-in will be treated as global add-in so that each user can use it.

For Excel 2003, you can directly add the add-in in Excel with one administrator account. Then this add-in will be global and every user can use it
directly. However, after you add the autosave add-in, the add-in will be disabled by default when another user starts excel for the first time. he will
need to enable this add-in.

For Excel 2002, I'd suggest you can copy the autosave.xla file into the directory: %programfiles%\Microsoft Office\Office10\Library. This is the
default directory for Excel to load the add-in at startup. This way, every excel user will use the Autosave add-in. You will find the add-in in "Tools->
Add-in".

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
MSDN managed newsgroup??

Autosave.xla is not included in versions later than Excel 2000 so your advice
is not valid for 2002 and 2003.

Try again.

Gord Dibben Excel MVP
 
Hi Gord,

MSDN managed newsgroup is one service of Microsoft for MSDN Subscribers. For more information regarding this, please visit the link:
MSDN Newsgroups
http://msdn.microsoft.com/newsgroups/welcomepage.asp

The autosave add-in has been removed from Excel in 2002 and 2003. However, you can download one autosave add-in from one Excel web site.
http://www.bmsltd.co.uk/MVP/MVPPage.asp
The Autosave.zip file will help the users to save the excel workbook automatically. Furthermore, you can also obtain the autosave add-in from other
site or company.

ZABU just want to know whether there is any limitation for the users who has installed the autosave add-in in Excel 2002 and 2003. I gave my
suggestion regarding this issue in the above post.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from
the Internet.
 
Actually, Jan Karel Pieterse's AutoSafe (note spelling) is slightly different
(and maybe much more useful).

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.

(I just learned about that!)
 
MSDN managed newsgroup is one service of Microsoft for MSDN Subscribers

Well these NGs have been around a lot longer than MSDN and of course do not
require a MSDN subscription.
 
Back
Top