Results 1 to 5 of 5

Thread: Create Excel Object

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2002
    Location
    India
    Posts
    3

    Question Create Excel Object

    I am trying to create an excel file with 3 work sheets. I get the data from an ASP File and pass it on to my vb dll which has a function to receive these arguments.

    When I try to execute the codefrom Win NT Server(IIS),

    Set ExcelApp = CreateObject("Excel.Application")
    ExcelApp.Application.Visible = True
    Set ExcelBook = ExcelApp.Workbooks.Add

    I am getting following error.

    VBScript Runtime Error: '800a01ad'
    ActiveX component Can't create object

    Can any one help please

  2. #2
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    Is Excel installed on the Server ?
    -= a peet post =-

  3. #3

    Thread Starter
    New Member
    Join Date
    May 2002
    Location
    India
    Posts
    3
    Of course yes.

  4. #4
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    -= a peet post =-

  5. #5

    Thread Starter
    New Member
    Join Date
    May 2002
    Location
    India
    Posts
    3
    I have checked this article and a few related with COM. But all those seem to be fine. Even a setting localserver32 in registry is set in short path. But I still have the problem. Like to know whether any security problem in NT Server, etc. I think the problem lies somewhere there only

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width