Date: Mon, 29 Jan 2001 09:20:05 -0500
Reply-To: "King, Raymond" <raymondk@OTSUKA.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "King, Raymond" <raymondk@OTSUKA.COM>
Subject: Q: Running Word VB macro via DDE and System topic
Is there a way to execute a VBA macro created in Word 97 from SAS via dde
using the System topic? There aren't any examples of doing this on the SAS
support site. None that I could find anyway!
a la -
/*** Start Example ***/
options noXwait noXsync ;
filename wordCMD dde "winword | system" ;
... open word doc using X command and put SAS to sleep until document is
data _null_ ;
file wordCMD ;
put "[error(false)]" ;
put "[close()]" ;
put "[quit()]" ;
/*** End ***/
This is all tied to trying to create PDF files from SAS 6.12 TS060.
The plan is to:
1) Create output .LIS files from SAS,
2) open those files in Word,
3) run a macro to Print to a postscript (.ps) file using the Adobe Distiller
4) distill the postscript files to .pdf files.
A SAS program will act as the batch driver by reading in a list of all .LIS
files in a directory, and then use a SAS Macro to execute the above steps
for each file.
Any insights would be appreciated and links to more information are welcome.
Project Leader, Scientific Programming
Otsuka Maryland Research Institute, LLC
800-562-3974, Ext. 2155
King, Raymond.vcf [application/octet-stream]