Trouble with LoadPicture method

[cswain99]

I have a picture object on my Sheet call Image2 and i am trying to put a picture into it with this method
"Image2.Picture = LoadPicture("C:\KPD55D.bmp")"
This code is in the sheet module itself
The issue is that I keep getting the error "Run-time error '481': Invalid Picture. The issue is that I can open the picture itself in paint when I click on it in the folder no problem. Any help would be nice

 

[Andrew Poulsom]

BMP files are definitely supported. Maybe it's a resolution issue (number of colours). Can you add the picture to the control manually?

 

[cswain99]

I can insert the image into excel. How do you manually insert an Image into an Image control?.
The image is located here "http://maps.wunderground.com/data/ndfdimages/T201103301500_ne.png" its a png format I just changed it to a bmp image

 

[Andrew Poulsom]

You use the Browse button next to the Picture property.

 

[Andrew Poulsom]

Your code worked fine for me if I saved the picture from that URL as a BMP (Excel 2003).

 

[cswain99]

I tried the browse button and It came back with the error invalid picture. This is really strange I wonder if their is a permission thing

 

[Andrew Poulsom]

I tried the browse button and It came back with the error invalid picture. This is really strange I wonder if their is a permission thing

Maybe, because as I said it worked for me.