I am currently trying to make a automated monthly report, which uses .jpeg files from a folder, and replaces existing pictures from my Word-Template. The .jpeg files in the folder looks good, but when i use the “replace picture in Word-File” and replace the pictures, they use the same size as the existing pictures… This makes the newly added pictures in the Word-file look odd, and not the way i want. Any way to come around this problem? Then please let me know
Welcome to the Community!
In fact Word is not the best tool for image-embedding. I this this can be done only by adding image from scratch instead of replacing previous image.
I do not understand your answer… At the moment my bot is taking a screenshot of a range in a Excel-file. This new image is to be inserted in the word file in a specific place. Over a period of the the range will get bigger and bigger, but if it does, it will not keep the correct size, when inserted. So you know, all text get greyed out, and it seems like it is zoomed in. Hope It makes sense
Ok. Now I get it
Hmm not sure if there is something you could do. Word is keeping dimensions quite strictly and having in mind that screenshot taken from excel can be bigger that word file the only thing I could suggest is to define other size after pasting it to the Word using attended automation. This might be tricky.
But what about instead of making screenshot you would grab copy of these excel data and paste them to the word file? As a table for example.
Will give it a try and reply back on this thread. It might be the solution!
yes replacing the picture will keep the size in order to keep the document layout. I agree that is a problem when different pictures have different sizes, will bring this up for maybe an improvement in future releases.
@HoriaBelu Could it be an idea, to add a feature where you could choose what size the should be inserted as?
Also, why is it not possible to instead of replacing a picture, just to insert a picture after a specific header/text or something similar?
@HoriaBelu would’nt it be possible to use the script from “Insert DataTable”, where it is possible to insert relative to text, and post it after?