Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have an xla file preventing me from opening new files | Excel Discussion (Misc queries) | |||
Preventing an excel file from being deleted by another user | Excel Discussion (Misc queries) | |||
stop excel file opened as read only if already opened by another u | Excel Programming | |||
How set file open path to filepath of file opened with Explorer ? | Excel Programming | |||
Preventing Excel opened through webbrowser "taking over" other instances of Excel | Excel Programming |