For some reason recently, everyone is suffering from spaces in %COMSPEC% - bizarre!

Anyhoo, try this:
Code:
Shell '"%COMSPEC%" /c "C:\Program Files\Cognos\cer3\bin\trnsfrmr.exe" -n2 -s "D:\Cubes\Net\ModelsCubes\Net Shipments.pyi"'