Print to File - Automating entry with vba

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
getitright said:
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.
Click to expand...

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
 
Back
Top