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

Adam wrote:
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.


Try Application.GetOpenFileName


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup