Merging or Adding two .csv files
 

One way:

Shell "command.com /c copy c:\file1.txt + c:\file2.txt, c:\dest.txt"

--
Jim Rech
Excel MVP

Merging or Adding two .csv files
 

"Joe" wrote in message
...
Can I use wild card in shell command?

Like copy c:\*.txt, c:\dest.txt

Thanks.
Joe

If they are ascii files you can always use type
and pipe the output to a filecat /?


C:\type c:\*.txt fred.txt

Keith

Merging or Adding two .csv files
 

Can I use wild card in shell command?

Whatever works from the command line should work from Shell.

--
Jim Rech
Excel MVP