Article View: comp.sys.mac.apps
Article #2363Re: Excel 4.0 add-ins
From: ra_novy
Date: Wed, 02 Sep 1992 18:46
Date: Wed, 02 Sep 1992 18:46
27 lines
1608 bytes
1608 bytes
Richard C. Long writes
>
> I dislike the way add-ins are handled in Excel 4.0. The add-ins Manager
> stores the full path of an add-in module, and complains if there is a
> single quote (') or a bang (!) in the path. Well, of course my disk is
> called "Rich's Disk" and Excel didn't like that.
This prompts me to comment on an experience I had with add-ins in Excel 3.0.
When I installed 3.0, my hard disk was named Novy's HD. I had to remove the
quote later because an auto-HD backup app that we use didn't like quotes.
Well, this caused a problem when I started using the Solver add-in later! It
seems that Excel kept the HD's old name, so it couldn't find the Solver add-in
file, which sits somewhere within the System Folder. I was fortunate to
remember the HD name change and suspect that it was the source of the trouble.
Re-installing the add-ins solved the problem.
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.
Bob Novy
ra_novy@dal.mobil.com
Dallas, TX
No profundity today.
Technical Details
Message-ID:
<9209021846.AA03126@mobil.com>Path:
arc1-ca.pugleaf.net!sparky!uunet!cis.ohio-state.edu!pacific.mps.ohio-state.edu!linac!att!ucbvax!DAL.MOBIL.COM!ra_novyShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!cis.ohio-state.edu!pacific.mps.ohio-state.edu!linac!att!ucbvax!DAL.MOBIL.COM!ra_novy From: ra_novy@DAL.MOBIL.COM Newsgroups: comp.sys.mac.apps Subject: Re: Excel 4.0 add-ins Message-ID: <9209021846.AA03126@mobil.com> Date: 2 Sep 92 18:46:01 GMT Sender: daemon@ucbvax.BERKELEY.EDU Lines: 27