(Leo) preventing MDI file to be opened
 

Hi,
I have an excel file for my payroll, in which each sheet belongs to an
individual. for sending each their info, I created a simple macro to print
out each sheet separately in to an MDI file in a specific folder.
the problem is that when i run the macro, the "Microsoft Document Viewer"
opens all files in separate windows as they are created, making an overflow
of RAM and windows opened. (though I put the Preview argument to False for
Printout method)
so how can I stop the files to be opened as they are being created by the
macro in VBA??!
--
Thans & Best regards
Leo, InfoSeeker