CMD.EXE /C COPY - Always Goes to My Documents. How to Change?

[AnonymousElle]

Hi All -

I'm trying to concatenate some Access exported text files together
using CMD.EXE /C COPY, as follows:
Shell("cmd.exe /c copy *.txt OneFile.txt")

But, this code looks for .txt files in My DOcuments. I want it to look
in C:\Reports.

How do I update the code to look in C:\Reports?

Thanks for any advice...

- Ellen

[AnonymousElle]

Well, I figured it out, if anyone ever needs to know... It's like
this:

Shell ("cmd.exe /c copy C:\Reports\*.txt OneFile.txt")

Thanks to all who tried!

- Ellen
On Oct 20, 12:47 pm, "AnonymousElle" <[e-mail]:

Hi All -

I'm trying to concatenate some Access exported text files together
using CMD.EXE /C COPY, as follows:

Shell("cmd.exe /c copy *.txt OneFile.txt")

But, this code looks for .txt files in My DOcuments. I want it to look
in C:\Reports.

How do I update the code to look in C:\Reports?

Thanks for any advice...

- Ellen