Results 1 to 2 of 2

Thread: Help needed to create VB.NET program, please Excel background.

  1. #1
    .NET Framework
    .NET 2.0
    Join Date
    Apr 2018

    Help needed to create VB.NET program, please Excel background.

    Hi everyone. I am totally new to VB.NET however I do have some experience with VBA in Excel. I thank in advance for any comment, suggestion and assistance.

    Using VB.Net I want to accomplish the following:
    Form 1-
    To be able to import an excel master file which will have a structure for data from another file. The structure is – Ref No. – Name – Contact No. – Amount. This file stays open in the background to access data.
    The import a second file to update or populate this master file with all the relevant data and then close the second file.
    On this form also I want to show some graphs in terms of number of names and total amounts.

    Form 2-
    Has a drop down combobox with text fields to populate. The combobox is populated with the list of Ref No from the master file in form 1.
    When the use selects a Ref No. from the combobox the text fields here in form 2 will be filled with the corresponding data from the master file from form 1. This could work using index value of combobox, I think.

    The use is able to edit data and save this date and export to an excel file also.

    Thank you once again.

  2. #2
    .NET Framework
    .NET 4.0
    Join Date
    Aug 2004
    Sydney, Australia

Similar Threads

  1. Replies: 0
    Last Post: 02-23-2013, 3:08 PM
  2. Replies: 5
    Last Post: 04-12-2011, 4:19 PM
  3. create an Excel sheet in
    By Signo.X in forum Third Party Products
    Replies: 2
    Last Post: 11-15-2006, 10:20 AM
  4. Urgent Help Needed regarding Vb.Net and C Program
    By dilipreddi in forum VB.NET General Discussion
    Replies: 2
    Last Post: 08-18-2006, 11:16 AM
  5. How to create excel 2003 spreadsheet from
    By tarunkapoor in forum Third Party Products
    Replies: 0
    Last Post: 04-10-2005, 1:35 AM


Posting Permissions

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