Compile error in Coolprop in Excel after upgrade

[Gerard Lardner]

I am running Excel 2007 on Windows 7 X64. Coolprop was working very nicely, installed about 2 years ago. But recently I upgraded it as I was trying to write a clear procedure for a colleague to install Coolprop in order for him to use my spreadsheets. Now Coolprop throws a compile error in CoolProp.xlam as soon as Excel is started , and again when Excel is closed.

I have tried moving CoolProp.xlam to the trusted library location, but to no avail.

This problem happens only on my PC at home; my office PC, also Windows 7 X64 but with MS Office 2016, has no problem with Coolprop.

Can anyone suggest what's happening and how I might fix it?

Gerard Lardner

[Ian Bell]

Upgrade your Excel at home :)  2007 is 10 years ago now. You could try installing the XLAM from an older version of CoolProp - perhaps 6.0 or so.

--
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.

[Jorrit Wronski]

Hi,

I am not sure what your problem is, but why not try the shiny new
installer that I made for Excel and EES?

https://sourceforge.net/projects/coolprop/files/CoolProp/6.1.0/Installers/Windows/

Regards,
Jorrit

> --
> 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
> <mailto:coolprop-user...@googlegroups.com>.
> To post to this group, send email to coolpro...@googlegroups.com
> <mailto:coolpro...@googlegroups.com>.

[Gert Nielsen]

I'm sorry but it does not work at all, it doesn't unwrap itself and it can't find its own bits and pieces.

I get a error message saying "The most recent error number is 53. Its message text is: File not found:CoolProp_stdcall.dll"

It works beatifully on my jobpc on windows 7, but on my own windows 10 nothing happens. Exept the error message. I am fully aware that most computer problems arise 50 - 75 cm from the screen, so what am I doing wrong, or what steps did I miss. I just use the installer and everything went haywire.

Gert Nielsen

2017-01-23 9:24 GMT+01:00 Jorrit Wronski <jo...@ipu.dk>:

Hi,

I am not sure what your problem is, but why not try the shiny new installer that I made for Excel and EES?

https://sourceforge.net/projects/coolprop/files/CoolProp/6.1.0/Installers/Windows/

Regards,
Jorrit

On 21/01/2017 01:50, Gerard Lardner wrote:

I am running Excel 2007 on Windows 7 X64. Coolprop was working very
nicely, installed about 2 years ago. But recently I upgraded it as I was
trying to write a clear procedure for a colleague to install Coolprop in
order for him to use my spreadsheets. Now Coolprop throws a compile
error in CoolProp.xlam as soon as Excel is started , and again when
Excel is closed.

I have tried moving CoolProp.xlam to the trusted library location, but
to no avail.

This problem happens only on my PC at home; my office PC, also Windows 7
X64 but with MS Office 2016, has no problem with Coolprop.

Can anyone suggest what's happening and how I might fix it?

Gerard Lardner

--
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
<mailto:coolprop-users+unsubscri...@googlegroups.com>.

To post to this group, send email to coolpro...@googlegroups.com

<mailto: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.

--
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 coolpro...@googlegroups.com.

[Jorrit Wronski]

Hi,

It looks like your Excel cannot find the dll:
(a) the DLL is not in a folder included in the PATH variable,
(b) some security feature (Windows or Antivirus) keeps Excel from
accessing the DLL.

I am running Excel 2010 and Windows 10 with CoolProp without any
problems, it also works on Windows 7 and Excel 2013 for me.

Have you tried removing all traces of an earlier installation? Maybe
there are some leftovers somewhere. You could start by going to the
add-on manager and disable whatever is left of CoolProp in Excel.
Afterwards, you can uninstall the Add-on and then you can try to search
your local disks for "(*coolprop*(xla|xlam|dll))", locate the files and
delete them.

Finally, go for a fresh reinstall of the add-on. I hope that helps.

Jorrit

On 28/02/2017 09:40, Gert Nielsen wrote:
> I'm sorry but it does not work at all, it doesn't unwrap itself and it
> can't find its own bits and pieces.
>
> I get a error message saying "The most recent error number is 53. Its
> message text is: File not found:CoolProp_stdcall.dll"
>
> It works beatifully on my jobpc on windows 7, but on my own windows 10
> nothing happens. Exept the error message. I am fully aware that most
> computer problems arise 50 - 75 cm from the screen, so what am I doing
> wrong, or what steps did I miss. I just use the installer and everything
> went haywire.
>
> Gert Nielsen
>

> 2017-01-23 9:24 GMT+01:00 Jorrit Wronski <jo...@ipu.dk <mailto:jo...@ipu.dk>>:

> an email to coolprop-user...@googlegroups.com
> <mailto:coolprop-users%2Bunsu...@googlegroups.com>
> <mailto:coolprop-user...@googlegroups.com
> <mailto:coolprop-users%2Bunsu...@googlegroups.com>>.

> To post to this group, send email to
> coolpro...@googlegroups.com

> <mailto:coolpro...@googlegroups.com>
> <mailto:coolpro...@googlegroups.com
> <mailto:coolpro...@googlegroups.com>>.

> Visit this group at
> https://groups.google.com/group/coolprop-users

> <https://groups.google.com/group/coolprop-users>.

> For more options, visit https://groups.google.com/d/optout

> <https://groups.google.com/d/optout>.

>
>
> --
> 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
> <mailto:coolprop-users%2Bunsu...@googlegroups.com>.

> To post to this group, send email to coolpro...@googlegroups.com

> <mailto:coolpro...@googlegroups.com>.

> Visit this group at https://groups.google.com/group/coolprop-users

> <https://groups.google.com/group/coolprop-users>.

> For more options, visit https://groups.google.com/d/optout

> <https://groups.google.com/d/optout>.

>
>
> --
> 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
> <mailto:coolprop-user...@googlegroups.com>.

> To post to this group, send email to coolpro...@googlegroups.com

> <mailto:coolpro...@googlegroups.com>.

[Gert Nielsen]

It seems to be workning now. Thank you. Would R448A an R449 be available anytime soon?

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.