Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP General (http://www.velocityreviews.com/forums/f65-asp-general.html)
-   -   CreateObject("Excel.Sheet") error (http://www.velocityreviews.com/forums/t800003-createobject-excel-sheet-error.html)

POLILOP 11-11-2005 04:54 PM

CreateObject("Excel.Sheet") error
 
When i try to do this

Dim ExcelFace
Set ExcelFace = CreateObject("Excel.Sheet")
.........

the browser says this
Error Type:
Microsoft VBScript runtime (0x800A0046)
Permission denied: 'CreateObject'
/mjenjaci/test.asp, line 5


I have given the IUSR permission to the folder but still the sam error



McKirahan 11-11-2005 05:08 PM

Re: CreateObject("Excel.Sheet") error
 
"POLILOP" <fmatosic@@inet.hr> wrote in message
news:e7FHUCu5FHA.4076@tk2msftngp13.phx.gbl...
> When i try to do this
>
> Dim ExcelFace
> Set ExcelFace = CreateObject("Excel.Sheet")


[snip]

Try

Set ExcelFace = CreateObject("Excel.Application")



Tom Kaminski [MVP] 11-11-2005 08:16 PM

Re: CreateObject("Excel.Sheet") error
 
"POLILOP" <fmatosic@@inet.hr> wrote in message
news:e7FHUCu5FHA.4076@tk2msftngp13.phx.gbl...
> When i try to do this
>
> Dim ExcelFace
> Set ExcelFace = CreateObject("Excel.Sheet")


see http://support.microsoft.com/default...d=kb;LN;257757

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserv...y/centers/iis/
http://mvp.support.microsoft.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS




All times are GMT. The time now is 07:33 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.