PrintFile

[tromao]

Good morning


I would like to know how can I print a file already in a folder with VBA code.

It's a *.ps file so I cannot(don't want aswell) to open it in the workbook, just print it to the printer.

Many Thanks

[Ron Coderre]

Many years ago...I used this kind of DOS command:

COPY /B C:\FOLDER\FILENAME.PS \\SERVER\PRINTERNAME

The "/B" indicates to DOS to perform BINARY transfer, instead of the default of Text.

In VBA, you coud probably use this construct:

Please Login or Register  to view this content.

See the SHELL command in VBA Help for more information.

Does that help?