Printing postscript file to disk from VBA

Posted on 2007-10-14
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 76

    Expert Comment

    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

    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


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Several part series to implement Internet Explorer 11 Enterprise Mode
    A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now