Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    opening autosave with wb open event (97 on win NT)

    I use the workbook open event to start Autosave...

    AddIns("AutoSave").Installed = True

    But Autosave's defaults are save every 10 minutes, and prompt for save.
    I want it to save automatically every 100 minutes.
    At present I change the settings manually every time. Can I add anything to the above code to get XL to do it automatically?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: opening autosave with wb open event (97 on win NT)

    I have never used autosave, but I played a little with it after you posted your question (so maybe someone who has used it more, might have better info.

    I could NOT duplicate this problem with XL97 using WinXP nor with XL97 using Win95. In BOTH cases, excel REMEMBERED what I had set in the tools-autosave options dialog. [Perhaps it is a WinNT issue?]

    I do NOT know WHERE it saves the info. I looked at the files that had been saved "today" and sorted by date. The only 2 that occured when I Changed or closed excel were offitems.log and steve8.xlb. But if i renamed them, excel recreated them (without any of the former details, of course) but STILL knew my "autosave options". I did find a registry setting that has them in, which maybe excel does NOT have access to change (WinNT has more strict security). Perhaps you could manually save it with regedit (or have an IT admin do it if a work machine)

    I could also find no VB code to access autosave objects to use VB to change them.

    I did find 2 KB articles,
    one that discusses the problem, but is for XL2000 and tells you to get the next service pack.

    The second is just how to add it

    Steve

  3. #3
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: opening autosave with wb open event (97 on win NT)

    CJ,

    Be aware, I am even more unfamiliar with Autosave then Steve is.
    If you are willing to experiment and take all risk on yourself then you can try the following piece of code.
    It worked for me at least once...

    Sub SetAutoSaveValues()
    Workbooks("autosave.xla").Names("Frequency").Refer sToRange.Value = 100
    End Sub

    If "Frequency" doesn't work for you then try "Frequency1"

    Regards,

    Jim Cone
    San Francisco, CA

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: opening autosave with wb open event (97 on win NT)

    Good Idea. I hadn't thought of looking at the named ranges in a workbook I didn't have access to. That does seem to work without the registry hack. Don't know what is all in the addin. It has 109 named ranges!

    Steve

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: opening autosave with wb open event (97 on win NT)

    All thise named ranges are there because Excel's ancient Autosave is completely written in XL4 (!) macros. It has never been updated since, apart from making it work in the next release.

    Being unhappy with Autosave, I wrote my own, called Autosafe.zip.

    I recommend all XL97 and 2000 users to download that one, since it is far more powerful: it also gives recovery options after a crash of XL.
    Find it at The Excel MVP page below.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •