Re: [coolprop-users] Coolprop Mac OS (Excel)

[Ian Bell]

Ok, I followed the following instructions and it definitely works for me.

Steps:

0. Search for all instances of CoolProp.xlam on your computer.  Delete them all.

1. Open Excel, uncheck CoolProp.Xlam in Tools->Add-ins. Close excel

2. Download the 32-bit dylib from http://www.coolprop.dreamhosters.com:8010/binaries/shared_library/Darwin/32bit__cdecl_calling_convention/ and put in ~/lib

3. I downloaded the xlam from http://www.coolprop.dreamhosters.com:8010/binaries/MicrosoftExcel/ and put in ~/lib

4. Open Excel.  Tools->Addins.  Select...  Open the xlam file.

5. Run the example.

Check that:

A. When you go to Tools->Macros->Visual Basic Editor, you see some code that starts with a #If Mac then

B. When you start to type =PropsSI, it tries to autocomplete

On Tue, Nov 11, 2014 at 2:25 PM, Ayoub Mekhzouni <evia...@gmail.com> wrote:

Don't be alone to find a solution in an informatic problem is also definitely a victory ahaha...

thanks again !

2014-11-11 20:00 GMT+01:00 Ian Bell <ian.h...@gmail.com>:

We will definitely find a solution, a bit of patience...

On Nov 11, 2014 11:57 AM, "Ayoub Mekhzouni" <evia...@gmail.com> wrote:

I am also reading this topic where you give an answer which worked :

https://github.com/CoolProp/CoolProp/issues/175

I am trying to understand where is the problem but a little bit complicated in english.

Hope we'll try to find a final solution ahah...

Ayoub

2014-11-11 17:54 GMT+01:00 Ayoub Mekhzouni <evia...@gmail.com>:

No doesn't work correctly too unfortunately... :(

2014-11-11 17:40 GMT+01:00 Ian Bell <ian.h...@gmail.com>:

How about this one : https://github.com/CoolProp/CoolProp/blob/master/wrappers/Excel/CoolProp.xlam

On Nov 11, 2014 9:52 AM, "Ayoub Mekhzouni" <evia...@gmail.com> wrote:

I download the lib file from :

http://www.coolprop.dreamhosters.com:8010/binaries/shared_library/Darwin/32bit__cdecl_calling_convention/

the xlam from :

http://www.coolprop.dreamhosters.com:8010/binaries/MicrosoftExcel/

I receive unfortunately the same error message from Excel...

Thanks you very much for your help.

Give me some news when it's possible for you.

Ayoub

2014-11-11 15:43 GMT+01:00 Ian Bell <ian.h...@gmail.com>:

I'm pretty sure that one is fixed, though perhaps I didn't commit my changes.  I'll check tonight. 

On Nov 11, 2014 9:34 AM, "Ayoub Mekhzouni" <evia...@gmail.com> wrote:

http://www.coolprop.dreamhosters.com:8010/binaries/MicrosoftExcel/

This one ? I am not sure but I think it's the ne I've installed.

Ayoub

2014-11-11 15:29 GMT+01:00 Ian Bell <ian.h...@gmail.com>:

Argh, you have the old xlam.  Download the one from BuildBot, then uncheck the xlam in excel, restart excel, select the new xlam

On Nov 11, 2014 9:25 AM, "Ayoub Mekhzouni" <evia...@gmail.com> wrote:

Don't seem it auto complete (i am not sure if I understood what you mean). 

Here some screens of the coolprop's code.

Ayoub

2014-11-11 15:18 GMT+01:00 Ian Bell <ian.h...@gmail.com>:

Yes I see what you mean..    When you start to type PropsSI, does it auto complete?  It seems like your xlam might not have been properly installed, though it sure looks fine.  If you go into the macro editor, can you see the coolprop code?  I think its Tools : Macros : Editor or something like that.

On Nov 11, 2014 9:11 AM, "Ayoub Mekhzouni" <evia...@gmail.com> wrote:

Thank you for your quick answer !

I used as you advice the terminal. I think that I didn't comitt a mistake.

To answer to your question : yes i read the same tutoriel to install coolprop on excel 2011 for Mac.

Actually I don't really have a concrete question, but I am not able to install coolprop and i really don't understand why...

Best regards

Ayoub

2014-11-11 14:35 GMT+01:00 Ian Bell <ian.h...@gmail.com>:

For part 1, I hope you are following the Mac instructions ( http://www.coolprop.dreamhosters.com:8010/sphinx/coolprop/wrappers/Excel/index.html#pre-compiled-binaries-for-osx ).  I guess you are confused by the location ${HOME}/lib?  At a terminal, you can type

echo ${HOME}/lib

And that will tell you where your home folder is.

Otherwise, what is your question?

Regards,
Ian

P.s. your English is fine!

On Nov 11, 2014 8:07 AM, "evian2108" <evia...@gmail.com> wrote:

Hi guys, 

since yesterday I try to get a current Coolprop build into Excel on my new Macbook pro 

environment. Can someone please have a look at this, it fails.

I only find this documentation : http://www.coolprop.dreamhosters.com:8010/sphinx/coolprop/wrappers/Excel/index.html

I think I don't really understand the steps of the part 1 of the tuto (I'm french)...

If someone could help me it would be so cool. 

kind regards 

PS : sorry for english mistakes (it's not my mother tongue)

--
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.
Visit this group at http://groups.google.com/group/coolprop-users.
For more options, visit https://groups.google.com/d/optout.