VBA code for Inserting an Image

Closed

adikademani Posts 5 Registration date Monday 24 October 2016 Status Member Last seen 24 November 2016 - 24 Oct 2016 à 16:14
Blocked Profile - 26 Oct 2016 à 17:03

Hi guys,

I am in an urgent need for a command or code to insert an image from any directory in my computer to a particular cell in Excel using VBA. For example, i have a .jpg file named ABK in my E:Drive and i want to get that pic to a cell A1 in Excel when it corresponds to the value ABK in cell B1.

Your guidance is appreiciated:)

Thanks

Vba insert image
Insert image into gmail signature - Guide
Broken image icon - Guide
Insert key - Guide
Vba find - Guide
Windows 10 disc image - Download - Windows

3 responses

Réponse 1 / 3

Blocked Profile
24 Oct 2016 à 17:04

So, is the file path going to dynamic? Meaning, will it always be stored in the same place, and called the same thing?

Post your code and we can help, we cannot produce code turn key for you.

adikademani
24 Oct 2016 à 17:13

Hi ac3mark, Actually i am new to VBA, i just want to know what command can be used to call a specific picture from the hard drive. I do not have any code as such. Looking forward for you guidance . thanks:)

Réponse 3 / 3

captainashish Posts 20 Registration date Thursday 12 May 2016 Status Member Last seen 28 November 2016
25 Oct 2016 à 05:10

Hello,

To insert a selected picture in excel:

ActiveSheet.Pictures.Insert('full path of the picture from your local drive')

The above code will simply insert selected picture in excel within the selected cell or range in its original size.

Thanks & Regards,
Captain Ashish

adikademani
25 Oct 2016 à 05:59

Hi Captainashish,

Thanks for the quick reply. I used that command as below. The file gets inserted into the selected cell but it does not get displayed. It just says "the linked image cannot be displayed. The file may have been moved,renamed or deleted." I tried the command with different pictures inn different folders, but still it shows the same message.

Looking forward for your guidance :)

Sub pics()

ActiveSheet.Pictures.Insert ("C:\Users\Public\Pictures\Sample Pictures\")

End Sub

Blocked Profile
26 Oct 2016 à 17:03

This is why i don't do turn key solutions. If we helped and guided you to the solution, you would learn. Just posting some cut and paste scripts, ALWAYS ends up with:

"IT doesn't work!"

Your path has no Image file attached to it:"C:\Users\Public\Pictures\Sample Pictures\"

that is a folder path. it should be: "C:\Users\Public\Pictures\Sample Pictures\imagefile.png"

Similar discussions

Inserting image in a particular cell in VBA

Inserting image files from a directory specified by text string

Insert picture in Excel macro which takes the file name refrence

Excel Picture Inserting Macro Help - Urgent

adding a loop to macro to insert pictures

Hide/Unhide an Autoshape or Picture in Excel

Similar discussions

Subscribe To Our Newsletter!