I'm dealing with the known issue of getting "Copy method of Worksheet class
failed" error after several repetitions of copying a worksheet without
closing the file. Here's the MS article on the issue:

http://support.microsoft.com/default...84&Product=xlw

In my particular instance the worksheets are being programatically copied
into another workbook (not the one they originated in) but I seem to have the
same problem. I've put OnTime events in place to close and save both
workbooks after set periods, but so far I'm still occasionally getting the
error.

Has anyone successfully worked around this error? If so, was it done with
automatic save/close or something else?

TIA
--
n00b lookn for a handout :)