| Date: | Wed, 1 Apr 1998 17:14:48 -0500 |
|---|
| Reply-To: | "Brucken, Nancy" <BRUCKEN@WOLF.RESEARCH.AA.WL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU> |
|---|
| From: | "Brucken, Nancy" <BRUCKEN@WOLF.RESEARCH.AA.WL.COM> |
|---|
| Subject: | Invoking Excel macros from SAS |
|---|
| Content-Type: | text/plain |
|---|
I have an Excel VBA macro which requires an argument when called
[initialized as Sub ClearSelection (ClearType As String)]. How do I
invoke it from SAS? The closest I've come so far has been
filename cmds dde 'excel|system';
data _null_;
file cmds;
put '[SELECT("R1C1")]';
PUT '[RUN("ClearSelection", "Contents")]';
run;
but that still generated an error message. I'm using SAS 6.12, Windows
NT 4.0, and Excel 97. Is this even possible, or am I running into an
Excel 4 macro language restriction? Any suggestions would be greatly
appreciated!!!
Thanks,
Nancy
Nancy Brucken
Parke-Davis, QIP
(734) 622-5767
Internet address: brucken@aa.wl.com
|
