adding multiple pictures at once instead of one at a time
 

Here's the problem. We do construction on cell towers. We need to get upwards
of 50-150 photos (in original Resolution) and minimize them (without
compression or changing their normal size) to fit into boxes that are about
2"x3" so when they open up the document they can scroll through it quickly
zoom in and move along. Mainly the problem is its time consuming to insert
every picture and minimize them one by one. cutting down the time this
tedious procedure takes would increase our productivity and workflow by over
100%.

Thanks in advance.

adding multiple pictures at once instead of one at a time
 

Get in touch with me directly - email (remove spaces)
Help From @ jlatham site.com
I have some code that can probably help with this. Your problem is
two-fold: identifying the many graphic files to be added, followed by the
process to actually insert them into the workbook resized to fit properly.

I'd like to get a sample workbook with one or two of the graphic files
already inserted into it so I can see what you're goal is, along with copies
of 2 or 3 of the graphics to do testing with. You can attach those to the
email.

"KCTC" wrote:

Here's the problem. We do construction on cell towers. We need to get upwards
of 50-150 photos (in original Resolution) and minimize them (without
compression or changing their normal size) to fit into boxes that are about
2"x3" so when they open up the document they can scroll through it quickly
zoom in and move along. Mainly the problem is its time consuming to insert
every picture and minimize them one by one. cutting down the time this
tedious procedure takes would increase our productivity and workflow by over
100%.

Thanks in advance.