connecting to .csv files in variable locations

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.
 
J

Jacob Skaria

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
 
J

JDF

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV->Excel Data Problem 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
csv files 1
CSV files and having numbers and strings in there... 9
Files saved as csv files are actually saved as text files? 2
Convert csv to Excel files 1
Add csv to Open "All Excel Files" (XL2007) 3
SQL Union in MS Excel 2007 1

Top