running shell command in vba with error handling
Posted on 2013-01-17
I`m using shell command with xcopy in vba\excel
my problem is that i don`t have error notification.
PID=shell ("xcopy c:\test.txt c:\11\erc.dat /Y")
excute this line give no error , but the file test.txt is not copied into 11 folder.
also if test.txt is not existed it will not showing any error..
how to solve this problem.
thxn in regards:}