Date:         Mon, 8 Mar 2004 11:33:38 -0500
Reply-To:     Nathaniel_Wooding@DOM.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nat Wooding <Nathaniel_Wooding@DOM.COM>
Subject:      Re: Running a VBA macro using DDE
Comments: To: Kevin Roland Viel <kviel@EMORY.EDU>
Content-type: text/plain; charset=us-ascii

Kevin

According to Koen Vyverman Sugi 27 paper, "it is impossible to send VBA
commands throught a DDE link. It is possible to reun existing VBA macros
that are stored in g.g. the active workbook." He goes on to cite C. A.
Roper , paper 97, in the SUGI 25 proceedings.  If you do not find what you
need, check Koen's. The citation in Koen's paper shows Roper (2000b) but
either I did not print all of the references or there was a typo in his
text. There is only a single citation in the references.

Nat Wooding



                      Kevin Roland Viel
                      <kviel@EMORY.EDU>        To:       SAS-L@LISTSERV.UGA.EDU
                      Sent by: "SAS(r)         cc:
                      Discussion"              Subject:  Running a VBA macro using DDE
                      <SAS-L@LISTSERV.U
                      GA.EDU>


                      03/08/04 11:01 AM
                      Please respond to
                      Kevin Roland Viel






Is it possible to write a VBA macro for a currently created Excel
workbook?  If not, can I create a VBA macro beforehand (perhaps in a
another workbook) and run that VBA macro via DDE?

I have:

filename xl_sys DDE "Excel|system" ;

data _null_ ;
  file xl_sys ;
  put '[run("macro1")]' ;
run ;

I suppose I would like to have something like

  put '[run("C:\tmp\macro1")]' ;

if I cannot write the VBA macro "macro1" in my currently created workbook.


Thanks,

Kevin


Kevin Viel
Department of Epidemiology
Rollins School of Public Health
Emory University
Atlanta, GA 30322