Automting PDF output through Word 2000 & VFP6 2

[KarenLloyd]

Hi

Please could I get some suggestions for a reasonably priced pdf writer that can be automated using VFP6 and Word 2000.

I need this to produce batches of documents converted to pdfs without user intervention to confirm the file name for every print instruction.

Ideally I need this to work on Win98 as well as XP, if that's possible.

I've flicked thru the archives in the last few days but am straining to move on with a this recurring issue - Please can you help me?

I've seen solutions for Excel and for alternative drivers. But Word won't accept the pdf file name in the same way as Excel can.

I do apologise if I've just been entering the wrong search phrases over and over... in which case, if anyone can point me back in the right direction - I would be really grateful.

Thanks.

Karen

 

[JRB-Bldr]

There are a variety of PDF 'printers' which will accomplish the task. Some of them are even free.

While we do our PDF document creation directly through a VFP Report Form and not through Word, we most recently used this one and have been happy with it:

http://www.bullzip.com/products/pdf/info.php

but there are others on the web.

Merely use VFP to temporarily change your workstation's default printer to the PDF 'printer', do your Word automation including the Print command, and then set the workstation's default printer back to its original setting.

Good Luck,
JRB-Bldr

 

[KarenLloyd]

Thanks JRB-Bldr

I will certainly try Bullzip and let you know if it's the one for me.

I need to be able to processo the pdf printing without the file Save As dialog.

I'm not sure if that is possible with Word.PrintOut though

Karen

 

[baltman]

.displayalerts=.f.

 

[KarenLloyd]

Cheers to JRB-Bldr and baltman

The PrintOut method works with setting

oWord.ActivePrinter = "Bullzip PDF Printer"
oDoc.PrintOut(,,,mypdffile)
oWord.ActivePrinter = mydefprinter


That's superb! Thank you very much.

Karen

 

[KarenLloyd]

Ok- how wrong was I?

Although the PrintOut works unattended - it uses the Print to File option, even if I specify not to.

This means the PDF is unreadable as Acrobat cannot open it.

Back to the drawing board...

 

[KarenLloyd]

...of course I've just been trying to make life too hard.

Decided to go with the standard file name option as suggested by JRB-Bldr in thread1251-1474666

Time to move on!