VB to Excel

Hi all
Can any one tell me? How to insert data into Excel sheet from VB Application.

Thanks in advance
Subhasis

---------------------------------
Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.

[Non-text portions of this message have been removed]

•  8
  New Members

• C programming language
• Computer programming languages
• Java programming language
• Programming languages

Hi Subhas,

Following code insert data into excel sheet from VB application

Declare one variable for excel application like this

Dim xlsapp As New Excel.Application
xlsapp.Workbooks.Open filepath 'open old excel file

xlsapp.workbooks.add - new workbook

xlsapp.Cells(1,1)="Name"
xlsapp.Cells(1,2)="Studen_id"
xlsapp.Cells(1,3)="Mark1"

like this you used to store data into excel sheet.

regards,
M. Subramani

Subhasis Chanda < subhasis_chanda%40yahoo.com">subhasis_chandayahoo.com> wrote: Hi all
Can any one tell me? How to insert data into Excel sheet from VB Application.

Thanks in advance
Subhasis

---------------------------------
Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.

[Non-text portions of this message have been removed]





---------------------------------
Get the freedom to save as many mails as you wish. Click here to know how.

[Non-text portions of this message have been removed]

•  8
  New Members

• C programming language
• Computer programming languages
• Java programming language
• Programming languages