Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
run time error
hi folks..
wheni m trying to run my vba im gettin this run time error at this line.. lRet = objWSH.Run(sCmd, 0, True) runtime error : '2147024894(80070002)': method "Run" od object 'Iwshshell3' failed. snippet of the code... ------------------------------------------------------- ---------------------------------------------------- Set objWSH = CreateObject("WScript.Shell") -------------------------------------------------------- sCmd = "DNSCMD " & strDNSServer & " /recordadd " & strDNSZone & " " & strAlias & " " & strtype & " " & strIPAddr LogToLog "running:" & sCmd lRet = objWSH.Run(sCmd, 0, True) If lRet = 0 Then LogToLog "successfully created DNSAlias " & strAlias & " for IP-address " & strIPAddr & " on " & strDNSServer & "." & strDNSZone & "." Else LogToLog "*** !!! Error by DNSAlias creation " & strAlias & " for IP-address " & strIPAddr & " on " & strDNSServer & "." & strDNSZone & "." lCountErrors = lCountErrors + 1 End If cheers, Nuti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Help needed with Run Time Error 1004 | Excel Discussion (Misc queries) | |||
How do you sum a range of more than 30 cells. I get error each time I try. | Excel Worksheet Functions | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) |