opening a new excel sheet using VB

[gowthamkumar]

HII ...
please give me a code to open a new excel sheet using VB so that i can also directly add some contents in the cells of the excel sheet in VB itself ..
i ve use the existing excel sheet code given in this portal.. but its not working out..
so its giving error called at the
Sub Main()
Dim oExcel As Excel.Application
Dim oWB As Excel.Workbook
Dim oWS As Excel.Worksheet

Set oExcel = New Excel.Application 'its giving a error here... like User defined type not defined
oExcel.Visible = True


so please help me as soon as possible.

thanks.

Gow

[sahand]

Hi,

The code below maybe help you . In this case you can open Excel Application and write the content you want :

 
    Dim xlWb As Excel.Workbook
    Dim xlWSh As Excel.Worksheet
 
    Set xlWb = Application.Workbooks.Open(txtPath.text)
    Set xlWSh = xlWb.Worksheets(ActiveSheet.Name)
 

Good Luck,