I have been working with some code to take data from a
master workbook and create multiple other workbooks and
sheets. Everything works fine except that after copying
and pasting the data onto a secondary sheet, saving it and
closing it... I get a dialog box about emptying the
clipboard that requires input. Is there a way in the code
to empty the clipboard prior to closing my secondary
sheet? Or, perhaps a way to stop the dialog box from
appearing? I do not want the program interupted each time
a secondary sheet is closed... as I am creating a couple
hundred of them at a time.
Thanks!! patrick