Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with known issue
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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum issue | Excel Worksheet Functions | |||
Msg Box VBA Issue | Excel Programming | |||
Sum Issue Help! | Excel Discussion (Misc queries) | |||
For Next Issue | Excel Programming | |||
VBE Issue | Excel Programming |