running c# console application from excel and wait for app to finish

Question

I am running a c# console application from within Excel using the line of code below. The code is working fine. The process takes about 20 seconds to run. I was wondering how I get my vba code to wait for the c# application to finish before continuing execution of the code following this line?

I do not want to use a pause or similar function.

 Dim id As Integer
 id=Shell("""C:\MyFolder\bin\Debug\MyApp.exe"" /PARA1 " & p1 & " /PARA2 " & p2, vbNormalFocus)

Look at this question excel-vba-wait-for-shell-command-to-complete — dePatinkin
– dePatinkin, Commented May 13, 2015 at 13:39
Take a look at this thread: stackoverflow.com/questions/10279404/… — mageos
– mageos, Commented May 13, 2015 at 13:43

Community · Accepted Answer · 2017-05-23 12:30:06Z

2

You could try this code (inspired from this post):

Dim id As Integer
Dim wsh As Object
Set wsh = VBA.CreateObject("WScript.Shell")
Dim waitOnReturn As Boolean: waitOnReturn = True
Dim windowStyle As Integer: windowStyle = 1

id = wsh.Run("""C:\MyFolder\bin\Debug\MyApp.exe"" /PARA1 " & p1 & " /PARA2 " & p2, windowStyle, waitOnReturn)

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered May 13, 2015 at 13:58

Sébastien Sevrin

5,4132 gold badges25 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

running c# console application from excel and wait for app to finish

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related