Mac Excel 2016 - Error 53

[Mark335]

Have followed the instructions for installation of Coolprop for Excel on Mac.

Mac OS 10.12 Sierra

Excel 2016 Version 15.26

I followed all of the instructions to download and move the CoolProp.xlam and libCoolProp.dylib files to the .office directory

I used the 64 bit dylib file.

When I run "file libCoolProp.dylib" at the terminal window command prompt, I am returned the error "libCoolProp.dylib: cannot open `libCoolProp.dylib' (No such file or directory)"

When I run the coolprop function in excel, I am returned error 53.

I have tried to add the .office file to the bash_profile file to include it with my PATH, but the command "file libCoolProp.dylib" still return the same error that it cannot be found. If I type if the full path at the terminal window with the "file" command it returns the x64 value.

It seems the library file is not accessible in the path. Can you please help to provide a way to include the file location to the PATH?

The optional 2a step lists the path command with /another/path listed and I have tried the path to the .office directory and that did not work.

[Ian Bell]

Some comments:

"file libCoolProp.dylib" should be run in the .office folder, or by giving the absolute path to the dylib, as you found out

Seems like you did not follow the instruction about adding the .plist in step 2.  That is not optional, and the only way I know of to get Excel to accept that as a path for loading dynamic libraries.  Adding the path to ~/.bash_profile doesn't work either.

To be fair, the newest OS I have access to is OSX 10.11, so perhaps Apple has changed their sandboxing again in 10.12, but I imagine that this should work.

--
You received this message because you are subscribed to the Google Groups "coolprop-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to coolprop-users+unsubscribe@googlegroups.com.
To post to this group, send email to coolprop-users@googlegroups.com.
Visit this group at https://groups.google.com/group/coolprop-users.
For more options, visit https://groups.google.com/d/optout.

[Mark335]

Ian,

As I said, I followed ALL the steps and did create the plist file and did reboot my machine.

To be clear, I copied the text from the website, changed IHB to my user account name, created a text file and then named it my.startup.plist and placed it in the /Users/${USER}/Library/Group Containers/UBF8T346G9.Office directory for my user account.

I had a different error when I first created this file. I only logged out and logged back in. I later did a full reboot and that is the error I am reporting now.

On Tuesday, December 20, 2016 at 8:37:59 PM UTC-8, Ian Bell wrote:

Some comments:

"file libCoolProp.dylib" should be run in the .office folder, or by giving the absolute path to the dylib, as you found out

Seems like you did not follow the instruction about adding the .plist in step 2.  That is not optional, and the only way I know of to get Excel to accept that as a path for loading dynamic libraries.  Adding the path to ~/.bash_profile doesn't work either.

To be fair, the newest OS I have access to is OSX 10.11, so perhaps Apple has changed their sandboxing again in 10.12, but I imagine that this should work.

On Tue, Dec 20, 2016 at 3:48 PM, Mark335 <markh...@gmail.com> wrote:

Have followed the instructions for installation of Coolprop for Excel on Mac.

Mac OS 10.12 Sierra

Excel 2016 Version 15.26

I followed all of the instructions to download and move the CoolProp.xlam and libCoolProp.dylib files to the .office directory

I used the 64 bit dylib file.

When I run "file libCoolProp.dylib" at the terminal window command prompt, I am returned the error "libCoolProp.dylib: cannot open `libCoolProp.dylib' (No such file or directory)"

When I run the coolprop function in excel, I am returned error 53.

I have tried to add the .office file to the bash_profile file to include it with my PATH, but the command "file libCoolProp.dylib" still return the same error that it cannot be found. If I type if the full path at the terminal window with the "file" command it returns the x64 value.

It seems the library file is not accessible in the path. Can you please help to provide a way to include the file location to the PATH?

The optional 2a step lists the path command with /another/path listed and I have tried the path to the .office directory and that did not work.

--
You received this message because you are subscribed to the Google Groups "coolprop-users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to coolprop-user...@googlegroups.com.
To post to this group, send email to coolpro...@googlegroups.com.

[Ian Bell]

Ah, there's your problem.  The .plist should have been placed in ~/Library/LaunchAgents.  

To unsubscribe from this group and stop receiving emails from it, send an email to coolprop-users+unsubscribe@googlegroups.com.
To post to this group, send email to coolprop-users@googlegroups.com.

[Ian Bell]

Which for me is /Users/ian/Library/LaunchAgents

[Mark335]

Ian,

I mistyped what I sent before.

I have direct copy and pasted the information below changing account name to username placeholder.

Here is the location of my plist:

/Users/username/Library/LaunchAgents/my.startup.plist 

Here is the contents of the plist file.

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">

<plist version="1.0">

<dict>

<key>Label</key>

<string>my.startup</string>

<key>ProgramArguments</key>

<array>

  <string>sh</string>

  <string>-c</string>

  <string>launchctl setenv DYLD_LIBRARY_PATH "/Users/username/Library/Group Containers/UBF8T346G9.Office"</string>

</array>

<key>RunAtLoad</key>

<true/>

</dict>

</plist>

The libCoolProp.dylib is located in: /Users/username/Library/Group Containers/UBF8T346G9.Office/libCoolProp.dylib

The CoolProp.xlam is located in: /Users/username/Library/Group Containers/UBF8T346G9.Office/CoolProp.xlam 

 

I have tried to run the command from the plist directly on the command line with the same error when using the "file" command. Results below.

MacBook-Pro:~ username$launchctl setenv DYLD_LIBRARY_PATH /Users/username/Library/Group\ Containers/UBF8T346G9.Office

MacBook-Pro:~ username$ file libCoolProp.dylib

libCoolProp.dylib: cannot open `libCoolProp.dylib' (No such file or directory)

I have tried the launchctl command with many variations of quotes as well. The reverse slash in front the of the space in "Group\ Containers" was automatic as I dragged the file location direct from finder into a terminal window. I tried without the slash, with quotes, with slash with quotes. Same result.

[Ian Bell]

You should run file in /Users/username/Library/Group Containers/UBF8T346G9.Office, it doesn't follow the dynamic library loading logic.

It still seems like a bitness issue.  Is your excel 64 or 32 bit?  And are you sure that matches the dylib you have in that folder?

Once you reboot your computer, at the console, what does "env" give you?  The part we care about is the DYLD_LIBRARY_PATH.

Also, what are the ownership bits for the .plist file?

To unsubscribe from this group and stop receiving emails from it, send an email to coolprop-users+unsubscribe@googlegroups.com.
To post to this group, send email to coolprop-users@googlegroups.com.

[Thiago Jacinto]

Hi there,

I'm having the same issue here, using MS Excel 15.32 and macOS 10.12.3. I've followed the tutorial step-by-step twice now, and still got the Error 53 message "libCoolProp.dylib not found".

I've did the "$ file" test at Terminal.app and the Excel is 64-bit. I've decided to try even with the on-development builds (both 32 and 64-bit ones), without success.

Does anyone have other ideas?

[Ian Bell]

There is also this still(!) open issue: https://github.com/CoolProp/CoolProp/issues/1430#issuecomment-290437954 .

Right now my recommendation would be to give up and use python for your calculations - that's my general recommendation anyway.

To unsubscribe from this group and stop receiving emails from it, send an email to coolprop-users+unsubscribe@googlegroups.com.
To post to this group, send email to coolprop-users@googlegroups.com.

[Thiago Jacinto]

Hum, I see... Thanks anyway, Mr. Bell! 

--
You received this message because you are subscribed to a topic in the Google Groups "coolprop-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/coolprop-users/MFfUl2F1DMY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to coolprop-users+unsubscribe@googlegroups.com.

To post to this group, send email to coolprop-users@googlegroups.com.
Visit this group at https://groups.google.com/group/coolprop-users.
For more options, visit https://groups.google.com/d/optout.

--

-

Thiago Jacinto