title: How do I get java to open cmd and combine a folder of csv files?
body: <p>I am trying to get a java based macro I use to combine all of the .csv files it spits out into one, and the only way I know how to do that is to open up cmd and manually paste in the folder directory. I know almost nothing about java and pretty little about programming in general, and the person who make the macro i use is in a different country rn so i cant ask him for help.</p>
  
  <p>It takes forever to paste all of the results into one csv, and while using cmd is easier it would be nice if I could just have the macro do it for me. That said, I wanted to ask if it is at all possible to even do that?</p>
  
  <p>Any help would be appreciated! If possible, I would also like to get the macro to automatically combine the headings for the csv files. </p>
  
  <p>Also also, the macro has a dialogue box come up that then leads to you selecting the file directory. is it possible to have the cmd command reference the directory already defined by the macro?</p>
  
  <p>java based macro meaning like 20 lines of text written in java... idk i'm a biochemist not a programer. I'm doin my best. </p>