Date:         Wed, 19 Sep 2001 10:44:49 -0700
Reply-To:     "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Subject:      Re: Excel commands to write to filename cmds dde "excel|system" l
              recl=512?
Comments: To: "Brucken, Nancy" <Nancy.Brucken@PFIZER.COM>
In-Reply-To:  <6944FBE0F687D411823D00508B6095FA02372D6A@aaunderdog.resear
              ch.aa.wl.com>
Content-Type: multipart/alternative;

At 08:57 AM 9/19/2001 -0400, Brucken, Nancy wrote:
>Hi Frank,
>    You can store VBA macros in an Excel workbook on a network drive, and
>just point everyone's version of Excel to pull in that macro workbook when
>it starts up.  Then the application isn't quite as machine-dependent.


which is:

specified in the Alternate startup file location box on the General tab in
the Options dialog box (Tools menu).

HTH, too


>    Hope this helps,
>        Nancy
>
>Nancy Brucken
>Pfizer Global R&D, Ann Arbor
>Nancy.Brucken@pfizer.com
>(734) 622-5767
>
>-----Original Message-----
>From: Frank Poppe [mailto:Frank.Poppe@PWCONS.COM]
>Sent: Wednesday, September 19, 2001 8:18 AM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Re: Excel commands to write to filename cmds dde "excel|system"
>l recl=512?
>
>
>Thanks Koen.
>
>I will download the file and look there.
>(I can't use your alternative because I will not know on which machine
>the application will run, so I can't rely on anything stored.)
>
>Frank

------------------------------------------------------------
William W. Viergever          Voice  : (916) 483-8398
Viergever & Associates        Fax    : (916) 486-1488
Sacramento, CA 95825          E-mail : wwvierg@attglobal.net
------------------------------------------------------------
[text/html]