Insert and Arrange multiple Photos

[Stephen74]

I am looking for a script that will allow me to insert multiple photos, insert them in to a page and have them all evenly sized and spaced out - NOT - layered.

I have seen this done, and i've asked for the code, but I thought id ask on here as well. Tried looking online but can only find one that puts them all in vertically and not spaced out evenly across the page. Ie like...

1 2 3 4

5 6 7 8

[jolivanes]

It is no problem doing that but what are the restrictions?
How far do you want to go to the right? Like how many columns total?
Same for going down, how many rows?
It all depends on how many rows/columns you have per page and is the page oriented landscape or portrait.
Do you want 8 per page?
You asked for the code from someone else. What is wrong with that code?

Oh, and one more thing that could turn out be pretty important.
All photos/pictures in a folder or just selected photos/pictures?

[Stephen74]

All the photos would come from the same folder, but this would need to be specified each time. Its for reports and each report will have a seperate folder.
The number of photos per report would vary every time.
Orientation of the page doesnt matter to me but on portrait, 3 photos wide seems about right.
Photo orientation could be an issue. I wouldnt want a set size for each photo, rather a percentage reduction I guess.

The only problem with the code from someone I asked is them getting round to sending it.

[jolivanes]

It's getting past my beauty sleep time for me Stephen and I'll be busy with other things this weekend (visitors) so it'll be a few days before I can look into it.
I hope someone else in the meantime has some time for you.

BTW have you looked at the bottom under the similar threads section?

[Stephen74]

no one else?

[Marc L]

Many samples within this forum …

[JEC.]

Stephen, how about this?

Please Login or Register  to view this content.

[Marc L]

Just using named ranges like in this thread : Need VBA code to load Pictures from file on PC into Worksheet according to Date …

[JEC.]

That is only effective if you have a static and in particular low amount of pictures.

[Marc L]

Maybe, but let's wait this so poor initial post becomes a smart elaboration in order there is nothing to guess …

[Stephen74]

meh, edited out of politeness

[Stephen74]

Stephen, how about this?

Please Login or Register  to view this content.

Thanks, this isnt quite what I'm looking for. I would rather not have to specify a folder as the folder will be different every time. However, the layout is pretty much spot on. Is there a way to do this without needing to specify a folder, it would be better to have a folder location open up so i can select them manually.

[JEC.]

Ok then

Please Login or Register  to view this content.

[Stephen74]

Perfect, thanks JEC.

[jolivanes]

It's a good thing I was busy over the weekend because the gentlemen from the Netherlands supplied you with code I can only dream of.

[JEC.]

Thanks Jolivanes🙂

[jolivanes]

Since it appears that the majority of helpers on these sites look to be of the male variety, I took the liberty of calling you a gentleman. If this is wrong, my apologies.

[JEC.]

You are correct

[Stephen74]

And i'm back

Currently the photos insert about 20 rows down. What adjustment do I need to make to get it higher up?

There are currently 5 tabs in the report and I would like the photos to go in to tab two (called photos) but when I run the code It goes in to the first page. How do I change this please. I tried doing the code to sheet only but im probably doing it wrong. - OK, figured this one out