Article View: comp.sys.mac.apps
Article #2370Excel Macros (was Re: Excel 4.0 add-ins)
From: T.S. Eliot
Date: Wed, 02 Sep 1992 20:49
Date: Wed, 02 Sep 1992 20:49
28 lines
1792 bytes
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!toj8jReferences:
<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