How do I avoid opening multiple instances of same application.

[abhiab54]

Hi all,
I am facing a problem in VB. As many times i clicked on application created in VB, that many times it get opened. I want at one time only one instance of application should get opened & excecuted.

[iburyak]

Try this at a start up before any code executed.

[PHP]
If App.PrevInstanc e Then
AppActivate App.ProductName
End
End If[/PHP]

It should bring up front already running instance and close this one.

[Hemant Pathak]

if app.Instance then
exit sub
end if

[abhiab54]

Thanks everybody. Code is working fine.