Copy method fails in IIS
 

Hi

I have a (VB6) component that creates a new excel document. Within that document, the first sheet is copied n times (each copy is filled in with some data). When I run my component from another VB6 application, it works like it should. When I run that component from an asp page it fails for the following reason

Copy method of Worksheet class faile

The result is an excel document with only the first sheet, so I guess it fails already the first time the loop is entered
I use the following code to create a copy of the first sheet and make it the last one

For i = 1 To SomeValu
...
oEx.Worksheets(1).Copy after:=oEx.Worksheets(i
...
Next

All help would be appreciated

Thanx a lot
Domien