I have a form which uses shell to open another application and then OLE to get some info from it. This is all working great.
The problem is that no matter what window stle argument I pass (vbMinimizedNoFocus etc) the application takes the focus. I have tries vbHide which works but keeps the application open and because it is hidden, I can't then close it later.
Is there a way to show a hidden application after it has opened?
If not, how can I return the focus to Access after the app has opened. I have tried me.setFocus but it still does not return the focus to access.
The problem is that no matter what window stle argument I pass (vbMinimizedNoFocus etc) the application takes the focus. I have tries vbHide which works but keeps the application open and because it is hidden, I can't then close it later.
Is there a way to show a hidden application after it has opened?
If not, how can I return the focus to Access after the app has opened. I have tried me.setFocus but it still does not return the focus to access.