Hi ,

Did you get any solution on the above ? I have a similar requirement. 

Regards

I was able to make this work by using the screen recorder and automating the clicks (Insert > Pictures > Place in a cell > This device) and then automating the hot keys to type in the file location and file name of the picture. Using a variable to store the file location and name allows you to automate a process that uploads several different images.

There are two downsides to using the screen recorder to automate this process.

1. If the window size is different (for example full screen versus a small 420x 420 resolution), the UI will change to accommodate the different screen sizes. When the UI changes, the button layout in excel will also change. This means that certain buttons that you may click in full screen will not be available when the screen UI is smaller, and this will cause the bot to fail because it can’t see all of the buttons that it is expecting to see
2. If you run the bot on a device with a different version of excel than the one that you wrote your program in, the bot will fail. For instance, if you automate the button clicks of the excel enterprise edition and then try to run the bot on a device with excel 2019, the bot will fail because the layout is different between these two different versions of excel 

I am actively looking for alternative ways to implement automating images into excel because error number 2 that I listed above has caused my current bot to fail. Good luck

Hello, Lokesh

A simple way is to use Key stroke Action to simulate “Ctrl + C” from Picture window, and “Ctrl + V” with Excel sheet window. 

Example:

you can add some steps like “Delay” or “Wait - for picture application window” to increase accuracy. 

Best regards

Elwait

Also, there is a bot in the bot store that does this job pretty well.