infinite shell problem

[cfkorea]

I need some help for my excel vba program.

I use ShellRun code to execute external program (***.exe)

Public Sub ShellRun(sCommandLine As String)
Dim hShell As Long
Dim hProc As Long
Dim lExit As Long
hShell = Shell(sCommandLine, vbNormalFocus)
hProc = OpenProcess(PROCESS_QUERY_INFORMATION, False, hShell)
Do
GetExitCodeProcess hProc, lExit
DoEvents
Loop While lExit = STILL_ACTIVE
End Sub


But Sometime When I use this code,
Excel calls external program infinitely many times.

I don't know why because it works well in another computer.

can someone give me some tips or problems to solve this problem?

 

[cfkorea]

It occurs when I type all formulas in worksheet and enter shift+F9

 

[benbal]

Hi cfkorea,

I am using the shell function and I am having the same problem.
On my laptop it will work fine (it is using office 2010) and on another one running office 2007 it will open endlessly the external application.

Did you find the answer to your problem?

Thanks in advance.

 

[cfkorea]

Hi benbel.

I asked about this problem on many forums, and I found that there is no solution for this one.
We can't control the chain of calculation in Excel... I heard. So I decide to use Just Re entering Formulas, and make a macro to do that work.

I'll glad if you find other answer to this problem. Thank you.