As part of a larger script this is the only part that I cannot get to work. Your assistance would be much appreciated:-
RetVal = Shell("C:Usersuser1Documentsdfs_update.bat", 1)
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
The result :-
When I attempt to run this bat file from a command line the
dfscmd.exe executes correctly:-
The system error shown in the last img
confirms that the script works from the command line. So effectively if I can get it to respond like this when initiated from
excel vb it would be perfect.
The .bat file would contain multiple command lines that would utilise Microsofts
distributed file system to map/unmap dfs links to storage locations. If I can only get the .bat file executed from the excel
sheet that would be great.
Your asisstance/guidance would really be much appreciated.