Check Authentication/Role for VBA application - CCW

[far2low]

Folks...
Im a newbie n hope some1 can help out here..Ive a VBA Application (Intranet) which Id need to check users role and authentication to enable/disable some components.

I created a COM Class so that I could expose some properties of the IPrincipal Interface on the .NET framework for the VBA to check the roles...more like implementing....

If Me.User.IsInRole("MTN_Grp") Then
....
If My.User.IsAuthenticated = True Then
......

The created COM Class builds perfectly...but cant figure out how to implement these on the VBA side or whether some more code is needed...Please check the attachment.

Any help will be much appreciated.

Tx

 

[PlausiblyDamp]

What problems are you having when calling it from a COM client?

 

[far2low]

Im not able to simulate the statements...If Me.User.IsInRole....I pretty much wanna pass the details of the logged-on user through..and provide only the appropriate resources...Dont know how to word the syntax on the COM client...and dont know whether the wrapper created is actually right or need some more work...its taken me a while to get to this stage..Please let me know what you can think of it..
thx for replying.