hi i am creating a program that needed an excel app., and i already do it, at first no error, but after a sudden, an error appeal, here is a error. Microsoft.Office.Interop.Excel.Application' is not defined.
i am still new and still exploring in vb.net. thank you in advance!
Any help is highly appreciated :)

Edited by Grazel: wrong grammar

4 Years
Discussion Span
Last Post by asarchit65

Can you post some code? looks like you have a object type where it expects a defined variable.

 Dim appXL As Excel.Application
        Dim wbXl As Excel.Workbook
        Dim shXL As Excel.Worksheet
        'Dim raXL As Excel.Range
        'Start Excel and get Application object.
        appXL = CreateObject("Excel.Application")
        appXL.Visible = True
        'Add a new workbook.
        wbXl = appXL.Workbooks.Add
        shXL = wbXl.ActiveSheet
        'Add table headers going cell by cell.
        shXL.Cells(1, 1).Value = ""

        'Format A1:D1 as bold, vertical alignment = center.
        With shXL.Range("A", "IV")
            .Font.Bold = True
            .VerticalAlignment = Excel.XlVAlign.xlVAlignCenter
        End With
        'raXL = shXL.Range("1", "1")
        'raXL.Formula = "=  "" ""  "
        'With shXL
        '    .Cells(2, 4).Value = ""
        '    .Cells(3, 4).Value = ""
        '    .Cells(4, 4).Value = ""
        '    .Cells(5, 4).Value = ""
        '    .Cells(6, 4).Value = ""
        'End With
        'AutoFit columns A:K.
        ''raXL = shXL.Range("A1", "K1")
        'Make sure Excel is visible and give the user control of Excel's lifetime.
        appXL.Visible = True
        appXL.UserControl = True
        ' Release object references.
        'raXL = Nothing
        shXL = Nothing
        wbXl = Nothing
        appXL = Nothing
        Exit Sub
        MsgBox(Err.Description, vbCritical, "Error: " & Err.Number)

that 's my code..


You have to create the object by

 Dim appXL As New Excel.Application

CreateObject is how you would do it in vbScript, not vb.net. See here for an example.

You also have code that appears outside the Sub/End Sub (Err_Handler:). Not good. I assume that somewhere you have an On Error GOTO. You should be using Try/Catch instead.

Edited by Reverend Jim


1) Check your Excel dll references.
2) when you deal with excel object , your machine should have Ms office pakage and have permission to access that.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.