Excel GIF storage - no external files

[theta]

I have been experimenting with an old spreadsheet that allows for the use of embedded GIF files within excel. The GIF's are converted to raw data and stored in number format, which is then used to create a userform complete with animated GIF.

By storing the data in the cells, it means the images can effectively be moved with the spreadsheet without relying on external files / structure.

I have reached a stopping point - would it be possible to the same for JPG, PNG or BITMAP images?

(If some progress can be made to import an image other than the demo, then I will happily create an addin for everybody to use complete with ribbon / toolbars)

[theta]

The GIF animator :
https://dl.dropboxusercontent.com/u/99937114/Forums/GifAnimation.xls

The GIF data extractor :
https://dl.dropboxusercontent.com/u/99937114/Forums/GifDataToSheet.xla
(This is an addin and creates a ribbon entry but no Alt+F8 macros or functions that can be called - I think I may remove the VBA protection and combine it with the animator into a single addin file)

EDIT :
The GIF data extractor : (code exposed)
https://dl.dropboxusercontent.com/u/99937114/Forums/GifCreator.xls
All credit goes to the author however, his website is no longer live so he cannot be contacted. I extracted the module and sheet code and have created this workbook to facilitate the creation of GIF data

[Paul_Hossler]

If the animated part is not important, I used a UserForm as a 'holding container' with a bunch of UF-compatible pictures on it.


Another macro then displayed the 'real' UF and put the required picture one it then displayed that UF to the user

If you're interested here's a demo.

WS button displays a UF and the top button on that UF will change the picture based on the 7 images that are on the 'holding' UF