LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (September 2001, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments: To: "Brucken, Nancy" <Nancy.Brucken@PFIZER.COM>
In-Reply-To:  <6944FBE0F687D411823D00508B6095FA02372D6A@aaunderdog.resear
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 > >(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 : ------------------------------------------------------------


Back to: Top of message | Previous page | Main SAS-L page