| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why Copy/Paste fails using Offset & Resize of myRange? | Excel Discussion (Misc queries) | |||
| Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
| Open method of workbooks fails when Excel is hosted in IE | Excel Programming | |||
| SaveAs method fails when saving to FTP site. | Excel Programming | |||
| Goto method fails when assigning a macro to a button | Excel Programming | |||
Threaded Mode
