get value from an external application that was opened via shell command

  • Thread starter Thread starter Jesse Aufiero
  • Start date Start date
J

Jesse Aufiero

I'd like the user to be able to click a button on my access form and open an
external application (built in .net 1.1). This application needs to behave
like a modal dialog within access. The user will do what he needs to in
this application and then close it. At that point, the remaining VBA code
after the shell command should resume.

How can I accomplish this kind of 'modal' behavior with an external
application. Is it possible through managed VBA code or APIs?

Thanks!
 
Well, I think I spoke too soon. This 'shellwait' method is buggy at best.
If i click the access application more than 4 times, it shifts access into
'not responding' mode. Also, access does not repaint for the duration of
the shellwait, so if the user moves the shelled app, resizes it, or drops
down a comobox dropdown beyond the borders of the shelled app's form
borders, access does not repaint itself, leaving a visual garbled mess under
the shelled application.

Is there a shellWait that works better? Or an all together different
strategy to force access to 'wait' for a shelled app to close before
resuming vba code?

Thanks!
 
Back
Top