Using picture file in Excel VBA and want to go to sharepoint

[bRent2D2]

1st time post on here.

So I have an extensive form system and one of the forms allows the user to select % complete of a certain task. To do this, the users click the picture of a 25% incremented pie graphic. So if the item is 25% complete, they click the blank pie and the image changes to 1/4 of the pie being filled in. To grab these .jpg's they are located in a folder in the same directory as the spread sheet in a shared network folder. The problem now is that management wants the sheet on sharepoint. Ideally, I'd put the .jpgs in the sheet itself so it wouldn't have to go external to grab these image files. Is there a way to paste the .jpg's right into the spread sheet and be able to reference them through code?

Thanks in advance.

Here's the current code that lies within the button click method:

frmPIO.Controls("btnItem" & btnNumeral).Picture = LoadPicture(filePath + "PIO Progress 25 (Resized).jpg")

[Fettertiger]

Hi brent,

why not put both pictures and spreadsheet on sharepoint?

Regards

Fettertiger