Print to File - Automating entry with vba

[Guest]

I'm trying to create a postscript file without user
intervention. I'm having a tough time of it.

Both setting a printer to "Print to File", and automating the
name of the filename in vba seems to be a mystery.

We did this in MS-DOS database programs like Paradox and Dbase
using macros and scripting languages with ease.

How can this be done an Access 2003 using VBA?

Thanks for any approaches.

 

[Tony Edgecombe]

I'm trying to create a postscript file without user
intervention. I'm having a tough time of it.

Both setting a printer to "Print to File", and automating the
name of the filename in vba seems to be a mystery.

We did this in MS-DOS database programs like Paradox and Dbase
using macros and scripting languages with ease.

How can this be done an Access 2003 using VBA?

Thanks for any approaches.

You can easily create a "print to file" printer in Windows, add a
printer using a PostScript driver and when it asks you for a port
select a new Local Port and enter the path to the file for the port
name. Then whenever you print to that printer it will write to file
and you can pick this up in your VBA code.

There is an article on how to do this at http://www.frogmorecs.com/arts/print-to-file.html

Tony Edgecombe
www.tonyedgecombe.com