Excel Limit on Worksheet Copy?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Back
Top