loading of pictures from MS Teams folder in userform

[Bonny4k]

Hi,

Is it actually possible for Excel to load pictures into a userform, which are stored in a shared MS Teams (Sharepoint) folder?

I am working on a userform which loads a .jpg picture based on a number in a cell, but I only get it working if the jpgs are stored either on regular network folder or my harddrive.

It would be really helpfull if anyone knows a way this can be done, or can clarify that this is indeed not possible. Thank you.

[Andy Pope]

Assuming you have access to the site it should be possible.
The LoadPicture command does not appear to be able to handle UNC paths, which mean mapping the path to a drive.

Please Login or Register  to view this content.

In the example code you need to get the correct address to the team site.
I find the easiest way is to open an excel file in the correct location. Then use ?Activeworkbook.fullname in the immediate window.

[Bonny4k]

Assuming you have access to the site it should be possible.
The LoadPicture command does not appear to be able to handle UNC paths, which mean mapping the path to a drive.

Please Login or Register  to view this content.

In the example code you need to get the correct address to the team site.
I find the easiest way is to open an excel file in the correct location. Then use ?Activeworkbook.fullname in the immediate window.

Hi Andy,

sorry for replying so late, but the forum went down the same day. Lucky for me your reply was sent to me by the automatic post notification email!
I tried your solution and it worked like charm. To always get the correct Sharepoint address the following command is working:

Please Login or Register  to view this content.

During testing it also helped a lot to make a button which deletes the temporary network drive, so to avoid the error message "this drive already exists".

Adding and instantly deleting a temporary network drive to get Exel to load pictures from Sharepoint feels a bit like using a sledgehammer to crack a nut, though.


Thank you very much for your help!