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 :

Expand|Select|Wrap|Line Numbers

  
    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,

opening a new excel sheet using VB

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ