Issue to shell command

Question

Issue to shell command

Peter_1985 2,736

Hi,
Can you help to error like

due to 2nd line below?

                    Command0 = "cmd /c copy /y ""C:\cmp3g\CODECO_ERROR_a\" & File0 & """ ""C:\cmp3g\CODECO_ERROR_a\" & Str0 & """ "  
                    Shell (Command0)

Adrian Bowles 86 Reputation points

2021-02-17T22:02:38.323+00:00

I guess I'll ask the question - is there a need to shell to the command line copy command.

Could you not simply copy the command using

System.IO.File.Copy (SourceFilename, DestinationFileName, True)

which will copy the file.

Or use the VB My.Computer.FileSystem.CopyFile method

Both of which are much simpler and less problematic than shelling out to copy and determining success or not.

Accepted answer

1 additional answer

Your answer

Adrian Bowles 86 Reputation points

2021-02-17T22:02:38.323+00:00

I guess I'll ask the question - is there a need to shell to the command line copy command.

Could you not simply copy the command using

System.IO.File.Copy (SourceFilename, DestinationFileName, True)

which will copy the file.

Or use the VB My.Computer.FileSystem.CopyFile method

Both of which are much simpler and less problematic than shelling out to copy and determining success or not.

Answer 1

Hi @Peter_1985 ,
In order to copy the file, try:

        Command0 = "cmd.exe /c copy /y C:\cmp3g\CODECO_ERROR_a\" & File0 & " C:\cmp3g\CODECO_ERROR_a\" & Str0  
        Shell(Command0)

Hope it could be helpful.

Best Regards,
Xingyu Zhao
*
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Peter_1985 2,736

Hi,
Due to issue like

for last line below

                    sSrcFile = "C:\cmp3g\CODECO_ERROR_a\" & File0    
                    sDesFile = "C:\cmp3g\CODECO_ERROR_a\" & Str0    
                    CreateObject("Wscript.Shell").Run "cmd /c copy /y " & Chr(34) & sSrcFile & Chr(34) & " " & Chr(34) & sDesFile & Chr(34), 0, True

What permission should be adjusted below?

Xingyu Zhao-MSFT 5,381 Reputation points

2021-02-22T01:50:58.92+00:00

Hi @Peter_1985 ,
Since your question is related to vbscript, you can post your question in this forum for more help.

Share via

Issue to shell command

1 additional answer

Your answer