| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
connecting to .csv files in variable locations
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. -- JDF |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
connecting to .csv files in variable locations
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 --------------- Jacob Skaria "JDF" wrote: 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. -- JDF |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
connecting to .csv files in variable locations
Thanks!
-- JDF "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "JDF" wrote: 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. -- JDF |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding files in a folder. Variable not defined error. | Excel Discussion (Misc queries) | |||
| stacked column with series in variable locations | Charts and Charting in Excel | |||
| Retrieving Cell Data From Variable Files | Excel Worksheet Functions | |||
| can you automatically save files to two different locations? | Excel Discussion (Misc queries) | |||
| Trying to access different files depening on a variable | Excel Discussion (Misc queries) | |||
Hybrid Mode
