Ever needed to Insert images into Excel, NO not just one or two but a Directory full of image files eg. A good source is your browser Tmp files...just copy image files to another Directory and run this routine.
See below for;
- Graphics filters supported
- Code comments / Pre requesites
Excel 2000 supports these Graphics Filters:
Computer Graphics Metafile (.cgm)
CorelDRAW (.cdr) file
Encapsulated PostScript (.eps) file
Enhanced Metafile(.emf)
Graphics Interchange Format (.gif) file
JPEG File Interchange Format (.jpg) file
Kodak Photo CD (.pcd) file
Macintosh PICT (.pct) file
PC Paintbrush (.pcx) file
Portable Network Graphics (.png) file
Tagged Image File Format (.tif) file
Windows Bitmap (.bmp, .rle, .dib) file
Windows Metafile(.wmf)
WordPerfect Graphics (.wpg) file
Hanako (.jsh, jah, and .jbh)
FlashPix (.fpx)
Code comments:
This code
- Inserts Image files from a Directory you select
- together with the image files name
- It automatically formats the cell to fit the size of the image.
DownLoad: