Date: Wed, 19 Sep 2001 17:10:38 +0200
Reply-To: Frank Poppe <frank.poppe@PWCONS.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Frank Poppe <frank.poppe@PWCONS.COM>
Subject: Re: Excel commands to write to filename cmds dde "excel|system" l
recl=512?
Content-Type: multipart/alternative;
Thanks Nancy,
but the final application may be circulated to anywhere, so even network
drives are not general enough.
==Frank
] -----Original Message-----
] From: Brucken, Nancy [mailto:Nancy.Brucken@pfizer.com]
] Sent: woensdag, september 19, 2001 14:57
] To: 'Frank Poppe'; SAS-L@LISTSERV.UGA.EDU
] Subject: RE: Excel commands to write to filename cmds dde
] "excel|system"
] l recl=512?
]
]
] 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.
] 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
]
[text/html]
|