By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Oct 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <ellenchris...@gmail.comwrote:
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
Oct 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.