Results 1 to 3 of 3

Thread: how to convert excel data to csv using vb

  1. Apr 12th, 2007, 09:15 AM #1
    vbqueries
    vbqueries is offline

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    1

    how to convert excel data to csv using vb

    Hi Friends,

    This is Krishna murthy. I have problem on vb. actual prb is how to convert excel file to csv using vb. can anyone knows this code please help me.

    Thank u
    krishna murthy
    Reply With Quote Reply With Quote
  2. Apr 12th, 2007, 07:48 PM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: how to convert excel data to csv using vb

    Hi Krishna and welcome to Forums!

    What version of Vb do you use - VB6 or VB.net? You should've posted your question directly in one of those forums instead.
    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  3. Apr 13th, 2007, 03:01 PM #3
    Al42
    Al42 is offline
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: how to convert excel data to csv using vb

    The easiest way:

    Automate Excel. (See Si the geek's tutorial.) Open Excel invisible. Open the .xls file. Save it as a .csv file. Close Excel. (I convert 5 .csv files to .xls files every week that way.)
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.
    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
    Please Help Us To Save Ana
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width