execute command line in VBA

[Teaser]

Hi All,

 

I have a requirement of running the dos command line below in VBA. Any help with the code/syntax will be much appreciated.

 

c:\> eRaiseFlag.exe /FlagName:CreateFolder

 

Thanks

 

TS

[Teaser]

Please note running the cmd directly works fine.

[maniac]

Edit, ignore that - you said VBA not VBS. Edited September 14, 2010 by maniac
Read the question properly.

[Teaser]

thanks maniac.. hope you can help

[dwhyte85]

strDOSCMD = "cmd.exe /c ..."

sCmdLine = strDOSCMD

'SEND TO DOS

dblRetVal = Shell(sCmdLine, vbHide)

Send Dos Commands (post 3)

Edited September 14, 2010 by dwhyte85

[Teaser]

thanks dwhyte85.. i'll give this a go