I'd shell to DOS and then copy all the .csv files to one .csv file on my
harddrive. Then open that one file:

Windows start button|Run
cmd (win2k or winXP)
command (win98)

copy d:\myfiles\*.csv c:\all.csv

exit
to get back to excel and open c:\all.csv

(Modify d:\myfiles to match your CD drive letter and path.)




Spanic wrote:

I need to copy multiple .csv files into Excel so that i can analyse the
information. The .cvs files are on CD, there are many of them and i do not
wish to open each one and then have to save them. Any clues?

--

Dave Peterson