connecting to .csv files in variable locations

  • Thread starter Thread starter JDF
  • Start date Start date
J

JDF

A data application saves numerical results as Excel .csv files into different
Windows folders (as sub-folders within a main folder) every time that it
runs. I need to be able to sequentially bring selected .csv files into a
single Excel 2007 reporting template that I am setting up to analyze the
data. What is the best way to do this? Thanks in advance.
 
Either you need to go for an excel macro....

OR

from command line copy the .csvs to a single file and open in Excel.
copy *.csv test.txt/b


If this post helps click Yes
 
Thanks!
--
JDF


Jacob Skaria said:
Either you need to go for an excel macro....

OR

from command line copy the .csvs to a single file and open in Excel.
copy *.csv test.txt/b


If this post helps click Yes
Click to expand...
 
Back
Top