ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   DOS Command (https://www.excelbanter.com/excel-discussion-misc-queries/211246-dos-command.html)

Troy 2006

DOS Command
 
I know this is not the ideal place to post, but I need to know what is the
exact proper format to copy a file from one drive to another drive when the
folder name contains a space in it.
Example:
I created a file called "Autocopy.bat"
The command line goes as follows:
xcopy c:\Folder\main.xls d:\Main Files\

The problem I'm having is the space between "Main Files" is not recognized
by DOS. How can I format this so the main.xls copy is made to D:\Main Files
???

Daniel.C[_2_]

DOS Command
 
Give a try to d:\"Main Files"\
Daniel

I know this is not the ideal place to post, but I need to know what is the
exact proper format to copy a file from one drive to another drive when the
folder name contains a space in it.
Example:
I created a file called "Autocopy.bat"
The command line goes as follows:
xcopy c:\Folder\main.xls d:\Main Files\

The problem I'm having is the space between "Main Files" is not recognized
by DOS. How can I format this so the main.xls copy is made to D:\Main Files
???




Dave Peterson

DOS Command
 
Untested:

xcopy "c:\Folder\main.xls" "d:\Main Files\"

Why use XCopy when you're copying a single file.

And if you're doing this in a macro, you may want to look at VBAs FileCopy
command.

Troy 2006 wrote:

I know this is not the ideal place to post, but I need to know what is the
exact proper format to copy a file from one drive to another drive when the
folder name contains a space in it.
Example:
I created a file called "Autocopy.bat"
The command line goes as follows:
xcopy c:\Folder\main.xls d:\Main Files\

The problem I'm having is the space between "Main Files" is not recognized
by DOS. How can I format this so the main.xls copy is made to D:\Main Files
???


--

Dave Peterson

Troy 2006[_2_]

DOS Command
 
Thank You!!!
You guys are so awesome!

"Dave Peterson" wrote:

Untested:

xcopy "c:\Folder\main.xls" "d:\Main Files\"

Why use XCopy when you're copying a single file.

And if you're doing this in a macro, you may want to look at VBAs FileCopy
command.

Troy 2006 wrote:

I know this is not the ideal place to post, but I need to know what is the
exact proper format to copy a file from one drive to another drive when the
folder name contains a space in it.
Example:
I created a file called "Autocopy.bat"
The command line goes as follows:
xcopy c:\Folder\main.xls d:\Main Files\

The problem I'm having is the space between "Main Files" is not recognized
by DOS. How can I format this so the main.xls copy is made to D:\Main Files
???


--

Dave Peterson



All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com