We help IT Professionals succeed at work.

Printing postscript file to disk from VBA

1,090 Views
Last Modified: 2012-08-14
I am working in VBA MS Excel, opening up an MS Access object and then printing reports.  I want to print to a file.  I will use ghostwriter, I guess, to convert a postscript file to PDF.  But for now, I want to print a range of pages to a file.  

I've been reading posts and going all over the place on this.  It seems like it should be easy.  I'm trying to set up a printer that will print to a file and can't do it.  How do I set up a printer that will print a postscript file to the hard drive?

Comment
Watch Question

GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
Have you considered saving the report as an rtf file and opening it as a document in Word?

You print to a file in Word

Author

Commented:
This is for my client, and he is clear what he wants.  He wants a PDF in the end.  This is a series of reports for his client.  There will be dozens of files, so the process has to be automated.

My client uses ghostscript, which seems like a good product.  All I need to do is get it to a postscript file and then it's a one line shell command to have ghostscript convert it to PDF.

It's weird, it really shouldn't be hard to do this.  Save a file to Postscript in vba.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.