Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Printing postscript file to disk from VBA

Posted on 2007-10-14
Medium Priority
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?

Question by:dougfosterNYC
LVL 77

Expert Comment

ID: 20074391
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 Comment

ID: 20075330
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.
LVL 46

Accepted Solution

tbsgadi earned 1500 total points
ID: 20076409

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dropbox has a relatively new feature called Smart Sync.  This feature allows Dropbox Professional (not plus) and Dropbox Business (if enabled) users to store information in Dropbox WITHOUT storing any files on their computer.
Each password manager has its own problems in dealing with certain websites and their login methods. In Part 1, I review the Top 5 Password Managers that I've found to be the best. In Part 2 we'll look at which ones co-exist together and why it'…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question