How to suppress prompt using XCOPY in Shell

When I am at the command line, if I type the following:

XCOPY C:\ABCDIR\ABC.XLS F:\BACKUP /I

It will copy the file from C: to F: properly without prompting me.

I have this batch file (Q.bat) and the content is:

XCOPY %1 %2 %3

In my VB code, I have the following block:

sfile = "C:\ABCDIR\ABC.XLS"
dfile = "F:\BACKUP"
p ="/I"
Shell ("q.bat " & sfile & " " & dfile & " " & p)

When I run it from VB, it executed the Shell function, but it paused and asked me to answer wether C:\ABCDIR\ABC.XLS is a File(F) or Directory(D).

How can I suppress the prompt in VB?

Thanks.

Re: How to suppress prompt using XCOPY in Shell

Code:

C:\>xcopy /? Copies files and directory trees. NOTE: Xcopy is now deprecated, please use Robocopy. XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W] [/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U] [/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z] [/B] [/EXCLUDE:file1[+file2][+file3]...] source Specifies the file(s) to copy. destination Specifies the location and/or name of new files. /A Copies only files with the archive attribute set, doesn't change the attribute. /M Copies only files with the archive attribute set, turns off the archive attribute. /D:m-d-y Copies files changed on or after the specified date. If no date is given, copies only those files whose source time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. Each string should be in a separate line in the files. When any of the strings match any part of the absolute path of the file to be copied, that file will be excluded from being copied. For example, specifying a string like \obj\ or .obj will exclude all files underneath the directory obj or all files with the .obj extension respectively. /P Prompts you before creating each destination file. /S Copies directories and subdirectories except empty ones. /E Copies directories and subdirectories, including empty ones. Same as /S /E. May be used to modify /T. /V Verifies the size of each new file. /W Prompts you to press a key before copying. /C Continues copying even if errors occur. /I If destination does not exist and copying more than one file, assumes that destination must be a directory. /Q Does not display file names while copying. /F Displays full source and destination file names while copying. /L Displays files that would be copied. /G Allows the copying of encrypted files to destination that does not support encryption. /H Copies hidden and system files also. /R Overwrites read-only files. /T Creates directory structure, but does not copy files. Does not include empty directories or subdirectories. /T /E includes empty directories and subdirectories. /U Copies only files that already exist in destination. /K Copies attributes. Normal Xcopy will reset read-only attributes. /N Copies using the generated short names. /O Copies file ownership and ACL information. /X Copies file audit settings (implies /O). /Y Suppresses prompting to confirm you want to overwrite an existing destination file. /-Y Causes prompting to confirm you want to overwrite an existing destination file. /Z Copies networked files in restartable mode. /B Copies the Symbolic Link itself versus the target of the link The switch /Y may be preset in the COPYCMD environment variable. This may be overridden with /-Y on the command line.

Looks like /Y then?

Re: How to suppress prompt using XCOPY in Shell

When I typed it on the command line, /i was the right perimeter and it worked.

The problem is that it doesn't work when I shell it.

I think I read it somewhere that shelling XCOPY doesn't pick up the perimeter.

Re: How to suppress prompt using XCOPY in Shell

Ahh, I see what you're doing now.

In your program you are trying to run q.bat with a /i switch, but that won't do anything here. Instead you probably need the /i inside q.bat on the Xcopy line.