VBA

Question

am working on a VBA coding from excel to STAAD 
 Before Select server 6 update the following VBA used to run staad file from the excel 
 After the update this command is not working. Can somebody help me out on that. 
 
 cmnd = "C:\SProV8i SS6\STAAD\SProStaad\sprostaad.exe /s" & filepath Shell "CMD /c" & cmnd

Surojit Ghosh · Answer

This shell function will not work in STAAD.Pro SS6 version. You can use the following shell function -- 
 
cmnd = """" & "C:\SProV8i SS6\STAAD\SProStaad\SProStaad.exe" & """" & " /s STAAD " & """" & filepath & """" 
Dim RetVal 
RetVal = Shell(cmnd, 1)