Get list of users from .ini file

[sharky12345]

I am just starting to play around with CONFIG files so forgive me is this is relatively straightforward, but I have searched online and can't find anything that answers this question.

I am going to create a list of users and access levels but need to know how to retrieve them. This is what I have so far in my CONFIG file;

[USERS]
User=Steve
Access=Administrator
User2=James
Access2=Administrator
User3=John
Access3=Standard

Ideally, I would want each user added to a worksheet with their access level in another cell, (that way I can run a VBA routine to check what sheet they can view).

The part I am struggling with is do I look for the user and access level within the CONFIG file, (and therefore how do I do that), or is it better to import each user into the workbook and check their access that way, (and therefore how do I do that!).

Any help or advice would be appreciated.

 

[Logit]

.
If you are ok with not using an INI file, what about a Select Case approach ?

Option Explicit


Sub chkMacroaccess()
Dim strName As String


    strName = InputBox(Prompt:="Enter password please.", _
          Title:="ENTER YOUR PASSWORD")
        
        If strName = vbNullString Then
           


           Application.DisplayAlerts = False
           ThisWorkbook.Saved = True
           Application.Quit


        Else


          Select Case strName
           
            Case "krunk"
                MsgBox "This would be accessing your Macro [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] " 'unhiding Sheet 2
            Case "logit"
                MsgBox "This would be accessing your Macro [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=2]#2[/URL] " 'unhiding Sheet 3
            Case "all"
                MsgBox "This would be accessing your Macro [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=3]#3[/URL] " 'unhiding all Sheets
            Case Else
                MsgBox "Sorry, wrong password."
                Exit Sub
          End Select


        End If


End Sub

 

[sharky12345]

Thanks, your suggestion will actually help with another project which does not use a config file, but I really need to understand config files if possible so want to try an identify a solution for this using an .ini file.

 

[jimrward]

This is similar to,a post of yours end of December to which I replied can you not keep the threads together it will help others as well as yourself