Singleton in VBA

[SAPMM]

Hi everyone,

I want to know whether it is possible to create Singleton Pattern in VBA?

Have anyone a idea? Thanks in advance.

SAPMM

[Lala]

Two seconds of Google brought this:

http://www.pcreview.co.uk/forums/sin...-t1889576.html

dont know if it helps but you can try ...

Cheers!

Lala

[SAPMM]

I have found the Solution. It´s not really Singleton but it works.

I check the Internet Explorer Sessions with Objects in conjuction with Windows Instance Check.

Short Example:

1. Create Variables
2. define browser (Local place of exe)

Then this Code..

Set objWMI = GetObject("winmgmts:" & _
"{impersonationLevel=impersonate}!
" & strPC & "\root\cimv2")
Set objProc = objWMI.ExecQuery _


Regards,
SAPMM