🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Excel Macros (was Re: Excel 4.0 add-ins)

#2370
From: T.S. Eliot
Date: Wed, 02 Sep 1992 20:49
28 lines
1792 bytes
In article <9209021846.AA03126@mobil.com> ra_novy@DAL.MOBIL.COM writes:
>
>I really like Excel, but I have one more gripe.  I started writing macros a
>couple of weeks ago, and I think the documentation is short on detail of how to
>do it (to put it kindly).  One thing that confuses me to this day is when a
>variable is a reference and when it is simply text.  I'll catch on to it
>sometime.

IMHO, this is a major failing of Excel.  It may be a marvelous macro language,
but it doesn't do me a damn bit o' good if the documentation is vague or
incomplete.

My particular complaint stems from writing macros that talk to more than one
worksheet.  I had to call Microsoft technical service twice and talk to two
different reps before someone offered a usable suggestion for a path syntax  
that would prevent the macro from writing to the macro sheet itself, rather
than to the (user-specified) worksheet that the macro was supposed to
address.  And of course the syntax for addressing remote sheets is explained
so poorly in the manual that I'm still not sure if their tech reps' solution
is present in the documentation.

(flame off--at Microsoft, not Bob)  
>
>Bob Novy
>ra_novy@dal.mobil.com
>Dallas, TX

tim jarrett (toj8j@fermi.clas.virginia.edu)
Technical Details
Message-ID: <1992Sep2.204902.15400@murdoch.acc.Virginia.EDU>
Path: arc1-ca.pugleaf.net!sparky!uunet!olivea!decwrl!sdd.hp.com!caen!destroyer!gumby!yale!yale.edu!jvnc.net!darwin.sura.net!uvaarpa!murdoch!fermi.clas.Virginia.EDU!toj8j
References: <9209021846.AA03126@mobil.com>

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!olivea!decwrl!sdd.hp.com!caen!destroyer!gumby!yale!yale.edu!jvnc.net!darwin.sura.net!uvaarpa!murdoch!fermi.clas.Virginia.EDU!toj8j
From: toj8j@fermi.clas.Virginia.EDU (T.S. Eliot)
Newsgroups: comp.sys.mac.apps
Subject: Excel Macros (was Re: Excel 4.0 add-ins)
Message-ID: <1992Sep2.204902.15400@murdoch.acc.Virginia.EDU>
Date: 2 Sep 92 20:49:02 GMT
References: <9209021846.AA03126@mobil.com>
Sender: usenet@murdoch.acc.Virginia.EDU
Organization: University of Virginia
Lines: 28