[AccessD] Cross Posted - Can only create 56 worksheets in Excel from VBA in Access

Hello

Using Office XP

I have a report produced in MS Access and output to Excel that creates a
copies of a template worksheet within the same workbook. When I get to
56 copies it falls over saying "copy method failed" (or something
similar).

On the same machine I can create hundreds of copies without problem (I
stopped at 550 without error)

Any one know what could be causing this limitation?

Cheers

Mark