mac: Expand Environmental Variables

[y2kbugger]

So from the time I submitted the last pull request until now, I have been hard coding the address for each user.

Now finally trying to use the feature again in 10.1:

PYTHON_WIN = "%LOCALAPPDATA%\Continuum\Miniconda3\envs\pydev\pythonw.exe"

yields:

 Could not load xlwings32.dll from either of the following folders: %LOCALAPPDATA%\Continuum\Miniconda3\envs\pydev, %LOCALAPPDATA%\Continuum\Miniconda3\envs

Since it has been so long I don't know when the regression happened. I figured you may know the answer right away before I dig in and attempt a fix.

[fzumstein]

Nope, can't say off the top of my head what could be causing it, but I found this related error: #616

[kaiaeberli]

how about using this: PYTHON_WIN = Environ("LOCALAPPDATA") + rest

[y2kbugger]

I think that fails on Mac

[sdementen]

Could we use on windows http://www.robvanderwoude.com/vbstech_data_environment.php#WSHShell to expand the environment variables ?
I have a use case too for an excel tool stored on a shared drive but using a local python install (via pipenv) that is stored in the %HOME%/.virtualenvs so I would like to have in the xlwings.conf the value "%HOME%/.virtualenvs" for INTERPRETER

[fzumstein]

we had this working once: #358 so we should just be able to see what broke it

[sdementen]

ok, so theoretically it should work but there is a bug to hunt, correct understanding from my part?

[fzumstein]

yes

…

On Mon, May 14, 2018 at 6:29 PM sdementen ***@***.***> wrote: ok, so theoretically it should work but there is a bug to hunt, correct understanding from my part? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <https://github.com/ZoomerAnalytics/xlwings/issues/615#issuecomment-388879586>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACKRoMmQeNblerzaSKYUrLQG5ES_SkNhks5tybEEgaJpZM4LopRE> .

[sdementen]

but I see the expand only in the Function ReadFile(ByVal FileName As String).
It should be at least called when assigning in PYTHON_WIN = GetConfig("INTERPRETER", "pythonw") ==> so probably best to do the expand in the GetConfig, no ?

[sdementen]

I have added at the end of the GetConfig function:

    ' Defaults
    If GetConfig = "" Then
        GetConfig = default
    End If
    
    ' Expand environement variables
    GetConfig = ExpandEnvironmentVariables(GetConfig)
End Function

with the function ExpandEnvironmentVariables doing the objShell.ExpandEnvironmentStrings magic and it works (ie the INTERPRETER is properly expanded)

[sdementen]

@fzumstein , do I prepare a PR for this ?

[fzumstein]

sure

…

On Tue, May 15, 2018 at 10:48 AM sdementen ***@***.***> wrote: @fzumstein <https://github.com/fzumstein> , do I prepare a PR for this ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://github.com/ZoomerAnalytics/xlwings/issues/615#issuecomment-389092011>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACKRoOd6ADWB7iD2UFvHVX7dmNQ-6nx9ks5typZDgaJpZM4LopRE> .

[sdementen]

when I fork from origin/master, I do not see the xlwings.bas. Should I just modify the .xlam and push it ?

[fzumstein]

yes, xlwings.bas is being built during CI. the xlam is the only source file for the VBA.

…

On Tue, May 15, 2018 at 10:58 AM sdementen ***@***.***> wrote: when I fork from origin/master, I do not see the xlwings.bas. Should I just modify the .xlam and push it ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://github.com/ZoomerAnalytics/xlwings/issues/615#issuecomment-389095189>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACKRoHYj-de__keIc3FecvG2iporQvx7ks5typjPgaJpZM4LopRE> .