Macro to auto-import images, resize them, and fit them to specific locations on the page

I don't even know if this is possible, but I wanted to ask.

I am trying to create a template document that, when a macro is activated, a specific number of images from a designated folder are imported into the document, resized to specific dimensions, and placed at specific coordinates on the page. The name of the image governs how they are imported into the document. For example, an image named "1" will be imported, resized, and relocated to a specific spot, an image named "2" will be imported, resized, and relocated to a specific spot, and so forth.

Ideally, I wanted to do this in Word, but the stricter layout rules that govern Word's interface makes me think this will be much more achievable in Excel.

Is this possible, and, if so, what would be the best way to go about it? I've been mainly researching how to do this in Word, and haven't been able to find any solutions that fit what I'm looking to do.

The VBA code below from Excel will print a couple of lines of text with a moveable picture on each page. Note that Word "SUCKS" when it comes to printing with VBA as the position of the cursor is not always obvious.

Please Login or Register  to view this content.

Hi EssoExplJoe - thanks for this. I have a few questions, because I am by no means an expert in VBA:

- Is this macro for Word or Excel? In your response you mention Excel, but the first comment in the code mentions "Word Document".

- Does this go in its own module, or in the ThisDocument object (if Word) or ThisWorkbook object (if Excel)?

- I don't need to add any text with this macro. Just images. And they each need to be resized/positioned differently. Image "1" will have a different size and position than image "2". Not only that, but these images will not be placed one after another with a blank line separating them. They have very specific, static locations on the page that ignore the traditional structure of the document. For example, most of the images are to be inserted in a table within the document. I may be reading it wrong, but the code you provided doesn't seem to address this kind of sizing/positioning. Am I reading it wrong?

This is an Excel Macro that prints from Excel to a Word Document. The aShape is resized by the .width and .height setting to whatever size you want. As far as putting the image into a word table, I haven't done that but suspect it will require a lot of trial and error. I spend several days to get this macro to put images on Word Pages. I think it might be simpler to write a macro that runs within a word document but haven't done that.