Results 1 to 20 of 32

Thread: A Class Module to store Images from a folder for later reuse in Workbook Excel VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #28
    VBAX Expert Dave's Avatar
    Joined
    Mar 2005
    Posts
    863
    Location
    "How does one store an IPicture interface to a Collection" ….. that is what this code does. Sorry sifar786 but I have no 64 bit instal to test code. As stated it works with gif, bmp, jpg and png files on my 32 bit install. I'm guessing that the VBA 7 declarations are still not correct. Good luck. Dave
    ps. Collections are not the same as a Dictionary and I have no idea if a Dictionary can contain images/objects.
    On second look, why are you not using the code I provided? U are not loading the pics in a collection, U are trying to create a picture from within the createpicture routine???
    PicCollect.Add PastePicture(CF_ENHMETAFILE)
    Is how the pics are loaded in the collection. So...
     sheets("picsht").image1.Picture =PastePicture(CF_ENHMETAFILE)
    would work for a copied picture if U use the code correctly.
    Last edited by Dave; 02-22-2020 at 08:03 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •