CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Location
    Sydney
    Posts
    23

    Unhappy Open an Excel Document

    Hello people

    Could someone please let me know how to open a Excel Document i have created so i can populate cells with some data i collect with a vb.net program

    The data is put in to a textbox, then i click a button and the data will be put in to the cells.

    Thanks Guys & Girls

  2. #2
    Join Date
    Jul 2005
    Posts
    14

    Resolved Re: Open an Excel Document

    HI
    Have A Nice Day

    Use This Code To Open Excel And add data to spread sheet coloumn

    Dim objExcel = CreateObject("Excel.Application")
    objExcel.Visible = True
    objExcel.Workbooks.Add()
    objExcel.Cells(1, 1).Value = TextBox.Text

    Where TextBox.text Picks Ur Data From TextBox

    This Is all
    Wait for ur Acknowledgement

    Scorpion

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured