Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    VB Screen data to csv

    Hello experts !
    I have an assignment to create a user form screen in Visual basic software when the user enters the data in the forums in respective parameters then click to button the data goes in csv but user defined cells range? Any example/guide line please.

    Always appreciate the forum Guru's

    Thanks
    Farrukh

  2. #2
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Which Office app? Maybe Access or Excel?
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  3. #3
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Hi Techcoach

    Thank for your reply in any application will be access or excel in the last the results goes in the csv?

  4. #4
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Hoiw many records of data will the user enter before saving to a CSV file?

    If it will be multiple records/rows enter before saving toa CSV then I would recommend Access. It can do what you want with a few lines of VBA code.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  5. #5
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Hi TechCoach,
    There is a daily data entry each day user change the date on the fly and enter the data it will be 100 + entry they save to csv but user defined cells because the format of third party import/export tool is different .Can you please share one sample example of it.

    I really appreciate.

    Thank you

  6. #6
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    I have create something similar for clients using Access.

    I first create the tables, forms and queries to allow the user to enter and store the data in a table(s). Next I create a button that will report the data. Access has sever built-in functions/methods for exporting. Which one you will use will depend on the desired export format.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

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