Hot to read from .ini-file in Excel

[Mollethewizard]

I suppose this is really simple, but, how can I read data from an ini-file to a variable in Excel?

The ini-file is situated in C:\USER and is named User.ini. It has a section [Employee] with Name=Sven Svensson

Let’s say I would like to read Name and put it in a variable X.

In Word I use PrivateProfileString but how is it done in Excel?

Mollethedog

 

[Bong]

first you can open the file:

    fnam = "c:\user\user.ini"
    Open fnam For Input As #1

Then you can read the file, one line at a time. Split the line on the "=" and select on the left side:

    Do While Not EOF(1)
        lnarr = Split(invar, "=")
        Select Case lnarr(0)
            Case "Name"
                x=linarr(1)
       End Select
    Loop
    Close #1

_________________
Bob Rashkin