var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Copy txt files into one txt file
I want to make an import file that is a txtfile.
I want to take multiple txt files and copy them into one file using vba...
In dos you can do copy txt1.txt + txt2.txt combined.txt and it will copy the first two files into the last.
Using FileCopy you can only copy one file, as it overwrites the destination.
it's quite a crude method, but it's quick and easy.
Just use a dos shell.
Raw but effective.
How would I pass it the copy command?
This works like a charm:
Thanks again for the help guys!
RunThis = "cmd /k copy c:\test\1.txt + c:\test\2.txt c:\test\shelltest.txt"
Set WshShell = CreateObject("WScript.Shell")
WshShell.Run RunThis, 3, False