Hi 23r23,
While there might be a finite limit to the number of characters in the command for the Run object, it is definitely more than your current command.
The problem in your case sems to be the path of your files. Since you have spaces in the folder names, you will have to enclose this in two sets of double-qoutes as below:
"cmd /c move /y ""C:\Program Files\National Instruments\Lookout 5.1\2004\*.*"" \\leo-2k1\Groups\Film\Data\2004"
Normally, as with the DOS command prompt, you would need only one set of double qoutes with paths that have spaces. However, Lookout expects two sets of double-quotes because one set of double-qoute is part of the command.
About moving the file while Spreadsheet object is writing to it, I don't think doing th
is is a good idea even if the cmd allowed it. Anyways, you can try it out to see if it does.
Regards,
Khalid