Microsoft VBScript runtime error: Permission denied: 'CreateObject' [Answered]RSS

1 reply

Last post Sep 23, 2013 08:30 AM by lextm

  • Microsoft VBScript runtime error: Permission denied: 'CreateObject'

    Sep 23, 2013 06:29 AM|nrk_hi|LINK

    Hi All,

    Please help me for the below error, past from 1 week i was searching in google to get the solution but i'm not getting at all.

    Please let me know is there any solution for the below error.

    Thank you

     


     

    set fs=Server.CreateObject("Scripting.FileSystemObject")

    set f=fs.CreateTextFile("c:\test\"&fileName,true)

    Set objExcel = CreateObject("Excel.Application") // Here i am getting the error (Microsoft VBScript runtime error: Permission denied: 'CreateObject')

    objExcel.Visible =True

    objExcel.DisplayAlerts =FALSE

    Set objWorkbook = objExcel.Workbooks.Add

    Set objWorksheet = objWorkbook.Worksheets(1)

    objWorksheet.Cells(1, 1).Value = Now

    objWorkbook.SaveAs("c:\test\"&fileName)

    objExcel.Quit

    Ravikumar
  • Re: Microsoft VBScript runtime error: Permission denied: 'CreateObject'

    Sep 23, 2013 08:30 AM|lextm|LINK

    http://support.microsoft.com/kb/257757/en-us

    Server side Office automation won't work.

    Lex Li
    https://lextudio.com
    ---------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.