Search:

Type: Posts; User: noobsesher

Search: Search took 0.15 seconds.

  1. Replies
    12
    Views
    21,359

    Re: vb.net Create NEW csv file

    I had one "Final workbook" that I Had opened.
    I had each csv file saved in a folder.
    I looped through this folder... Opened each csv file as an excel workbook (one by one)
    copied the used range...
  2. Replies
    12
    Views
    21,359

    Re: vb.net Create NEW csv file

    Thank you all for all your help.
    I ended up creating the text files and saving them in a folder as csv files.
    Then I created an excel application in vb.net and opened these csv files in excel as...
  3. Replies
    15
    Views
    5,756

    Re: Add sheet to text file

    Can you please explain what you mean by "jet text isam"
    I have googled it but still do not understand what it does.
  4. Replies
    15
    Views
    5,756

    Re: Add sheet to text file

    If I am not concerned about the MS version, (Everyone in my office is on the most current one) then does using a recordset make the task any easier?

    As of now I have 5 CSV files in a folder. I...
  5. Replies
    15
    Views
    5,756

    Re: Add sheet to text file

    Okay sounds good. I will use multiple csv files. It took almost no time at all to build the csv file with 5 million records. I am gonna see how it works breaking it up into 5 csv files then copying...
  6. Replies
    15
    Views
    5,756

    Add sheet to text file

    Hi I have a program which asks user for some inputs. Builds an array based on the output called fArray. Then writes fArray to a csv file (I need the output to be view-able in excel). The problem I am...
  7. Replies
    12
    Views
    21,359

    Re: vb.net Create NEW csv file

    Thanks for the reply.

    I am still confused.
    1) So what I really need to do is create a new text file with the extension ".csv"?
    2) Is there something like file.create(path\"NewFile.csv")
  8. Replies
    12
    Views
    21,359

    vb.net Create NEW csv file

    Hello, I am trying to create a new csv file but am having trouble getting started. All the examples I see, people are opening a csv file that already exists. When my program runs I want it to create...
  9. Re: Help outputting Millions of values to excel? csv?

    Okay I will give it a try. Thank you for the guidance.
  10. Re: Help outputting Millions of values to excel? csv?

    I need my final data to look like
    Variable1 Name Variable2 Name Variable3 Name
    val1 val1 val1
    val2 val2 ...
  11. Help outputting Millions of values to excel? csv?

    Hi. I have a program that opens a form, asks the user for some inputs (Variable names, range of possible values, #values in range) then creates all the output values and stores them all in an array....
  12. Re: Help writing Array of Arrays to excel worksheet

    The only reason i thought it might work is because you can name a range and set it equal to an array variable. In my case I have an array of arrays so I was hoping there would be a quicker way to...
  13. Help writing Array of Arrays to excel worksheet

    Hi I have an array of arrays that are created in a function and placed into fArray. Then I open a new excel worksheet, name a range, and set the range = fArray.
    Everything works except that in the...
Results 1 to 13 of 13



Click Here to Expand Forum to Full Width