Userform LoadPicture() not working on Mac

[truk2]

I have a macro that collects and loads various peices of data, before performing calculations. As part of the process I need to show the user a graph of the applied electrical load so that they can then make choices further down the line.

to do this, I generate a chart, save the image, and use loadPicture() to insert the image into an image object on the userform. On the mac this generates a "Sub or Function not defined" error for the LoadPicture() function

Here is my relevant code in the userform. LoadCurveChart is the name of the userform image object.

Please Login or Register  to view this content.

My search tells me that there is a general problem with LoadPicture() on Mac. If anyone has suggestions for fixes or alternatives, it would be greatly appreciated.

Note. This needs to run on other peoples computers, so any add-in requirements would need to be easy to install.

Thanks in advance

[Andy Pope]

I don't use Macs but have you tried this alternative?

https://www.rondebruin.nl/mac/mac024.htm

[truk2]

I hadn't seen this. I will give it a go tomorrow

[truk2]

It took me a while to get back to this project (other things became #1 priority)

I tried the RondeBriun code. When try to update the image, I get a "permission denied" error. I haven't found a solution to that yet

NB I have a public global boolean IsMac that flag if the code is running on Mac or not

Please Login or Register  to view this content.

[romperstomper]

You shouldn’t use backslashes in paths on the Mac. Use application.pathseparator instead.

[truk2]

Thanks, will try that

[truk2]

That worked.

I am now able to get through the LoadPicture method. I have the methods in to use preview if system is mac
However the existance of the loadpicture method in the other branch of the if statment throws a compile error as soon as the sub is accessed.

Please Login or Register  to view this content.

[romperstomper]

Use conditional compilation:

Please Login or Register  to view this content.

[truk2]

so the # makes it not compile the other path?

[truk2]

Use conditional compilation:

Please Login or Register  to view this content.

That worked. THANKS!

[romperstomper]

so the # makes it not compile the other path?

Correct. It will only compile the part relevant to the OS.