I am importing csv data and images from a folder into a temporary Excel workbook, which is used for readying the data for reporting purposes and resizing the data-related images. I then plan to import this data and corresponding images into my current workbook.


With ADO, i am able to import the csv data from the temporary workbook into my current workbook, BUT NOT THEIR CORRESPONDING IMAGES to generate different reports.


I came to know that a Custom Class Module can store objects for later use. My question is, is there a way to store the pictures directly from the folder into a Class Module by the picture name (instead of inserting them into the temporary workbook), for later use for generating reports in current workbook?


e.g. a Class Module to hold the pictures till the current workbook is open (maintain active session).


Is this possible?