Excel Limit on Worksheet Copy?

[George]

I am writing a VBA program in Access 2003 that does five tasks:
1. open an Excel workbook
2. copy a worksheet to a temporary worksheet
3. copy data from a recordset to the temporary worksheet
4. rename the temporary worksheet
5. save and close the workbook

Everything works fine, except in situations where more than 15 worksheets
need to be copied. At that point the VBA program dies. Does anyone have any
suggestions?

Thanks!

 

[Klatuu]

At that point the VBA program dies.

Make funeral arrangements?

An error number or description of the problem would certainly be helpful.
Also, posting the code couldn't hurt. My first thought is you may be blowing
memory, but without seeing your code or knowing what error you get, I can't
tell.

 

[George]

The error message is Run-Time error 1004 - Copy Method of Worksheet class
failed.

I just found this explanation on MS:
http://support.microsoft.com/kb/210684

Thanks

 

[Klatuu]

Looks like that should solve your problem.