Excel VBA - Using an http address as a full filename 1

[cardiac]

I have written an Expert Finder that displays the pictures of the Experts when you search. I do this by loading the jpeg photo into an Image control on a UserForm e.g.

imgExpertPhoto.Picture = LoadPath(strPhotoPath & "joe bloggs.jpg")

, where strPhotoPath is the path of the folder containing all the photos.

I want the Expert Finder to be used globally, so I want the photos to reside on an http server.

But when I try to use an http address e.g.

imgExpertPhoto.Picture = LoadPath("[URL unfurl="true"]http://10.129.129.30:8080/Expert%20Finder/Photos/"[/URL] & "joe%20bloggs.jpg")

the picture can't be found.

I have tried creating a Hyperlink object and using objHyper.Follow but nothing I try seems to work.

Please help.

 

[strongm]

thread222-708828 suggests some ways of achieving this

 

[cardiac]

Thanks strongm! It works!! I was using too many technical words on my search. I should have used normal English and then I would have found the excellent thread you submitted previously.

Thanks again!