Hi Aashish,
I cannot address your question directly, but I have a suggestion for
you and any programmer who is forcing users to login a second time to use
their file. Make it easier on your users by leveraging their OS login
session for identification instead. The following simple lines retrieve
the username (login name) from the OS, that you can then use to
automatically allow/disallow access to your file or data.
Dim sUserName As Variant
Dim WshNetwork As Object
' Get username from login domain
Set WshNetwork = CreateObject("WScript.Network")
sUserName = UCase(WshNetwork.UserName) 'Will retrieve the login
username from the OS
Jack M. O'Leary
On Tuesday, February 25, 2014 1:35:19 AM UTC-5, Aashish Watve wrote:
> Hi All,
>
> I have a excel file containing various macros that provide access to the
> file after everyone enters their login credentials. These login credentials
> are included in the hidden worksheets.
>
> This file would be used by my colleagues across the world. Now my
> colleagues in Germany would be using windows OS with German interface,
> those in Japan will use it with Japanese interface. My question is, are
> there any functions in VBA that are dependent on Windows language interface?
>
> Any hints? Suggestions?
>
> Is there a function that returns the Windows OS language?
>
> Any inputs, help would be useful.
>
> Regards,
> Aashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
