MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Jpg map pictures

  Asked By: Bakir    Date: Sep 18    Category: MS Office    Views: 1724

I have a Excel workbook with about 500 sheets each
containing 3 jpg pictures. I'm considering my options
regarding the best way for end users to view these
pictures (which are maps). I would like each picture
to appear full screen with zoom capabilities when
selected with options: jump back to scroll list of
sheet names, two buttons to jump to the other two
pictures, and a print picture options. I assumed that
Excel was going to work fine but am reconsidering
because of the lack of a zoom slider for the pictures.
Would you think that : A) Excel with a Zoom slider
button (macro found on the Web?)and customized menus
and hyperlinked image buttons, B) Excel export the
picture (and related hyperlinks)to Internet Explorer
C) A viewer common to all machines, or D) send to
Word or other MS-Office product; would be the best
way to procede?

Would compressing the pictures (via Excel compression)
lower the quality of the picture when zoomed in?

I am mildly proficient with VBA only in Excel.
any thoughts?



3 Answers Found

Answer #1    Answered By: Wilfred Young     Answered On: Sep 18

You seem to be pushing Excel quite a long way outside its (or your) comfort
zone. Yes, you could certainly do all this in Excel, but really you'll need
much more than mild proficiency in VBA or you'll be struggling.

This is the sort of thing that browsers do all the time - simply use hyperlinks
as needed to navigate around the small and large maps. Even zooming would
probably be easier in a browser than in Excel. An additional benefit is that
you could host all the maps centrally and not need to distribute this to all the
machines (if they are on a common network or the Internet).

As for compression ... as far as I know, JPG files can't be compressed any
further. The only thing you could do to make the files smaller would be to
reduce either the resolution or the colour depth. Both of these would lose

If you use a browser-based solution, you can use thumbnails for the small maps
and only send the full-sized versions of the ones the user wants to see.

Answer #2    Answered By: William Bouchard     Answered On: Sep 18

Don't know if it helps, but when you hold down the CTRL key, the
scroll button on the mouse becomes a zoom slider...

Answer #3    Answered By: Jean Bell     Answered On: Sep 18

I have an application in excel  which could be greatly enhanced by
having a map. How are yours placed/imported into the sheet?
The CTRL-scroll-wheel zoom works to three levels in this IE
browser when reading this group.
It zooms to many levels in my Excel 2002 and centers approx on the
cell selected. I pasted a jpg  into an Excel sheet and it zooms as
Next try turning on the macro recorder and see what the CTRL-
Scroll-wheel yields.
Now if I can plot lines on the jpg, I have what I want.

Didn't find what you were looking for? Find more on Jpg map pictures Or get search suggestion and latest updates.