I am trying to change multiple (say 100 images) in a document so that they are all the same height and width, and it is surprisingly difficult to do this in any reasonable manner. Additionally, in this same file I also have images that I don't intend to resize, so I cant just blast out some macro that skips changes every image at the same time. These images, by the way, are screen shots that I have captured and copied into the document from OneNote.



I have tried a number of methods but nothing seems to accomplish the goal of changing the pictures quickly. My current thought is to paste the images into an excel document, copy the images from excel into word, and then hope that when I update the excel image the word file also updates. This is not working out.

So I was hoping to have someone help me with a macro to resize the images to a certain width and height (say 5" wide by 3" tall). Preferably I could direct it to run on only the pictures I choose. Another, workable, solution would be to have a macro that makes all the images 3" tall with a locked aspect ratio. In the example file attached, the images would need to be sized so that the whole document is two pages long.

Thanks!
Fraser

Attached Files

resizing example.doc (86.5 KB, 14 views)

Let me try to rephrase this a bit: I am looking for some way that I can post a picture into a document and have it paste into a space of my choosing. Therefore, instead of having to resize each image after they are pasted in, they will automatically be the right size.

I should add, that for some reason (I am using 03 Word) I am unable to select multiple pictures at once, which would make things quite a bit easier and negate the importance of this post... Anyone heard of that before??

Thanks

Fraser