I'm trying to create a database diagram in Excel with VBA. I want to insert some pictures, which works great like this: mySheet.Shapes.AddPicture("C:\image.png",0,1,0,0,100,100)
Is there a way to embed the pictures in VBA so my code doesn't break if the image file gets moved? I would prefer to have the image encoded like data:image/png;base64, or SVG, but it wouldn't be horrible to have it inserted as a resource within the Excel file or a UserForm.
What is easy to do, but I only want to do as a last resort, is copy the image from a hidden tab. What other options do I have?