far2low Posted October 18, 2007 Posted October 18, 2007 (edited) Folks... I'm a newbie n hope some1 can help out here..I've a VBA Application (Intranet) which I'd 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 can't 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.:confused: TxCCW_Authentication_Role_Check.txt Edited October 19, 2007 by far2low Quote
Administrators PlausiblyDamp Posted October 20, 2007 Administrators Posted October 20, 2007 What problems are you having when calling it from a COM client? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
far2low Posted October 20, 2007 Author Posted October 20, 2007 I'm 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...Don't know how to word the syntax on the COM client...and don't know whether the wrapper created is actually right or need some more work...it's taken me a while to get to this stage..Please let me know what you can think of it.. thx for replying. Quote
Recommended Posts