Thanks Tom, interesting approach, the problem is, the images I'm working with
will be pretty dynamic, but this idea does put some wheels in motion.
I suppose I could code a program to copy the names of all the images into a
drop down from which the user would pick one; the program would then draw the
image.
Due to many users, I was hoping that each user could load a viewer which
they could drag to the appropriate max size for their screen, then all
subsequent images will fill the space available.
Bearing in mind that we need an in-house developed VBA solution, any other
thoughts? I noticed that there is a "SnapShotViewer" control, but I don't
know what it is or how to code it...
Thanks again for any further input.
"Tom Ogilvy" wrote:
this would be a good start:
http://www.mcgimpsey.com/excel/lookuppics.html
--
Regards,
Tom Ogilvy
"quartz" wrote:
I am using Office 2003 on Win XP.
Is it possible to code a simple image viewer inside an MS-Excel sheet;
perhaps code the drawing of an ActiveX control or some such control and then
allow the user to select a subfolder of images to display. There would need
to be a scroll button or other control to allow the user to scroll forward
and backward through the images contained in the folder.
I thought of just using the file open dialog and then switch the view to
thumbnail, but the images don't display large enough or in enough detail.
Any ideas? Thanks.