Re: Help on automating winword from SQR

["Walcker, Paul" <pwalcker@ISD.SBCOUNTY.GOV>]

OK Albert.  It sounds like what you are doing might be really cool.  I'm
quite interested in knowing both how you pulled this off and what the
business case was for devising this particular solution (you wouldn't
believe the hours I've spent doing forms for Human Resources).

>From what I can glean from your EMail you have already mastered the art of
getting a macro to run when launching Word.  I would be tempted to include
my "Print to File (in PS format)" in the macro itself.  If you are having
problems doing this from your macro I would suggest going to
www.tek-tips.com <http://www.tek-tips.com> .  That web site is full of
talented folks with great ideas.

Paul

-----Original Message-----
From: Albert Lau [mailto:a.lau@MAILBOX.GU.EDU.AU]
Sent: Tuesday, July 30, 2002 6:57 AM
To: SQR-USERS@list.iex.net
Subject: Re: Help on automating winword from SQR



Hi Richard,

Actually the SQR is generating a wordmerge report by calling a word macro.
What I need is actually convert it to a pdf format. I find a freeware
'ghostscript' which can convert a PS file to a pdf file. The only step I
need now is to automate the "Print to File" (in PS format) option of word.

Since it is a wordmerge and not a SQR report, I can't use the set print-type
option.

Regards

Albert Lau
Software Developer
BSS
Willet Centre Room 0.05, Nathan Campus,
Griffith University, Q 4122

Ph.: (07) 3875 5423
E-mail: A.Lau@mailbox.gu.edu.au



"Knapp, Richard" <KnappR@UMSYSTEM.EDU>
Sent by: "Discussion of SQR, Brio Software's database reporting language"
<SQR-USERS@list.iex.net>
30/07/2002 08:12 AM EST
Please respond to sqr-users

To: SQR-USERS@list.iex.net
cc:
bcc:
Subject: Re: Help on automating winword from SQR




Why not set your printer-type to PS?

Richard Knapp
Database Programmer/Analyst
Administrative Systems Project
University of Missouri System
573-884-3157
knappr@umsystem.edu


-----Original Message-----
From: Albert Lau [mailto:a.lau@MAILBOX.GU.EDU.AU]
Sent: Monday, July 29, 2002 11:42 PM
To: SQR-USERS@list.iex.net
Subject: Help on automating winword from SQR


Hi,

I am trying to call winword to convert a word document to
postscript format. Can anyone help? Thanks!

Albert