Excel97 Copy Method
Posted by Jerid on April 20, 2001 6:24 AM
I'm trying to copy a multiple sheets with charts into a new workbook. I can copy
about 40 sheets before I get an access violation error.
Microsoft has confirmed a problem with the Copy Method and claims that it's fixed
in 2000, but that doesn't help me because I'm using 97.
Possible Errors messages you could receive are -
Win95 - invalid page fault in MSO97.DLL or Excel.exe
NT - Excel.exe Exception access violation (My error) or Run-Time error 1004
I have tried all of the following to find a work around with no luck
1) API call to empty the clipboard after each copy
2) API call to sleep for 1 sec after each copy with a DoEvents
3) Changed the code from (Sheet.copy After Workbook.sheet) to (Add new sheet,
then copy and paste cells), this works but my charts don't copy with this
Has anyone found a work around?????