Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosaving Workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosaving Workbook
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosaving Workbook
Thank you for posting in MSDN managed newsgroup!
huh? -- Jim Rech Excel MVP |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosaving Workbook
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosaving Workbook
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!) "Wei-Dong Xu [MSFT]" wrote: 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. -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosaving Workbook
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. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autosaving an Excel Workbooks as versions | Excel Discussion (Misc queries) | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Can Excel 2003 prompt before Autosaving? | Excel Discussion (Misc queries) | |||
Problems Autosaving an excel file/sheet as Text | Excel Discussion (Misc queries) | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |