🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.apps
Article #9251

Excel AutoSave Macro error?

#9251
From: Paul E. Jacoby
Date: Tue, 21 May 1991 14:05
35 lines
2179 bytes
I just reported the following to Microsoft yesterday with regard to
Excel 3.0 for Windows.  Could someone try it out on Excel 3.0 for the Mac
to see if the problem has been fixed in the 'later' release?

(1) Start Excel 3.0. It opens with 'Worksheet1', ready for action.
(2) Open the 'AutoSave' add-in.
(3) Open the AutoSave dialog from the Options menu, and set the
    frequency to 'High'.
(4) Wait approximately 3.7519723 minutes :-) for the AutoSave to kick
    in.
(5) When AutoSave executes, click 'Save' in the first dialog.
(6) Press <RETURN> or click 'OK' in the Standard File dialog to accept
    the saved sheet name.

At this point, under Excel 3.0 for Windows, the sheet will be saved, and
the add-in (macro) will error at cell B98.  The reason appears to be
that once saved, the new worksheet is called 'Worksheet1.XLS'.  The name
change is throwing off the macro logic.

I suspect this will NOT happen on the Mac, since we don't do silly
things like appending '.XLS' to Excel worksheets :-)  However, I'd like
to know for sure (since I don't yet have Excel 3.0 for the Mac).

If someone is feeling _really_ generous, could they mail me a copy of
the Excel for Mac 'AutoSave' macro?  Then I could compare the two
versions to see if they are the same or not.

  Thanks much!
      Paul

-- 
| Paul E. Jacoby, 3M Company     |                                   |
| Maplewood, MN   55144-1000     |  Parachuting?  Why jump out of a  |
| => pejacoby@3m.com             |  perfectly good airplane?         |
|                 (612) 737-3211 |                                   |
Technical Details
Message-ID: <1991May21.140534.11942@mmm.serc.3m.com>
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!think.com!spool.mu.edu!cs.umn.edu!mmm.serc.3m.com!pejacoby

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!think.com!spool.mu.edu!cs.umn.edu!mmm.serc.3m.com!pejacoby
From: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Newsgroups: comp.sys.mac.apps
Subject: Excel AutoSave Macro error?
Summary: AutoSave Add-in errors on save of new sheet
Message-ID: <1991May21.140534.11942@mmm.serc.3m.com>
Date: 21 May 91 14:05:34 GMT
Article-I.D.: mmm.1991May21.140534.11942
Reply-To: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Distribution: comp.sys.mac.apps
Organization: 3M - St. Paul, MN  55144-1000 US
Lines: 35