[RESOLVED] Not able to use 'Set' when using Excel object

[elmnas]

Hi people,

I wonder if I missing any rerfence or something?
anyway I am not able to use "Set" in my code example:

I have made following code:

Imports Microsoft.Office.Interop.Excel

Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim xlApp As Excel.Application
Dim wb As Workbook
Dim ws As Worksheet


Set xlApp = New Excel.Application
Set wb = xlApp.Workbooks.Add 
Set ws = wb.Worksheets("Sheet1") 




end sub
end class

Could someone help me why?

[si_the_geek]

It's OK, just leave it out... the Set keyword is for old versions of VB (1998 and earlier) or VBA, you don't need it in VB.Net

Set is about telling VB/VBA you are using Objects, but as .Net is object oriented you don't need to tell it.