embed pictures from web by url in excel spreadsheet (or oo calc)

"I think the solution is to write a VBA macro that will retrieve the image and embed it into the worksheet.

I think that's the only way for this image to be automatically refreshed."