View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Code an image viewer inside XL

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.