Re: Sending multiple .lis files to Word

["Ivory, Wayne" <wayne.ivory@ILUKA.COM>]

The principle is the same Stephen.  Although you could hard-code pathnames,
we use environment variables that are set differently for
development/production.  Here is a cutdown version of a procedure we use
that does mail-merges in Word from a comma-delimited ascii file that the SQR
has created.

begin-procedure  Call_Winword Local

 LET $WinWord_String = getenv('WINWORD') || '\WINWORD.EXE '
  LET $Macro_String = '/mWSL_Merge '
   LET $Results_A_String = getenv('WORDDIR') || '\perfreva.doc '
  LET $Run_String = $WinWord_String || $Results_A_String || $Macro_String
  call system using $Run_String #return_Code
end-procedure Call_Winword


Wayne Ivory
Information Services
Iluka Resources Limited


-----Original Message-----
From: Stephen Ratliff [mailto:stephenratliff@HOTMAIL.COM]
Sent: Wednesday, 28 July 1999 2:46
To: Multiple recipients of list SQR-USERS
Subject: Sending multiple .lis files to Word


This may be an easy one for some. I am wanting to produce one or more
reports within a single SQR that are sent to Word for manual editing by the
same SQR. I've seen some examples of using the call function for Excel, but
I wasn't sure if the same would be true for Word, and I didn't quite
understand how the .xls file is passed to Excel.

Any help would be great. Thanks.

Stephen Ratliff

'The problem with democracy is that it counts the number of heads, not their
content.'


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com