View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam[_10_] Adam[_10_] is offline
external usenet poster
 
Posts: 1
Default Copying a selected prn file to printer.

I've written some code that saves a sheet to a prn file
(using the print to file option) then copies it to our
company fax server (to auto fax) and also a copies it to a
archive folder.

What I need help with now is I need some code that will
open some sort of box that will allow everyone to select
one of the .prn files in the archive folder so that I can
then allow it to be copied to a printer.

Ive been playing around with some of the open commands but
I dont actually need to open the file just select it, so
that it can be copied.

Thanks Adam