I am trying to run a batch file that copies of file to a local folder. It executes but it does not close the command window.
my code is: Shell ("cmd /C C:\Data\Database\TMS_Shipment_upload\TMS_Shipment_ Upload_Get_Site_Data.bat")
The batch file code is: P
Powershell /c Copy-Item -Path \\rccearprd03\F$\Data\Project\'TMS Shipment Upload'\TMS_Shipment_Upload_Site_Data.accdb -Destination C:\Data\Database\TMS_Shipment_upload