Singleton in VBA

[Former Member]

Hey everyone,

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

Have anyone a idea?

Greez

[thomas_brutigam2]

Two seconds of Google brought this:

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

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

greetings

Thomas Br

[Former Member]

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 & " ootcimv2")

Set objProc = objWMI.ExecQuery _

...

Greez Stefan