Insert pictures as a note with macro

[Akos]

Hello, Is there any macro what can insert pictures (jpg; jpeg) into note section in excel?
The best could be that, the macro can insert it into any column's note section (so not just an exact column) and also create the note for the insert.
If there is a macro for this, after the insert process, can I somehow compress the pictures?

I attached an example about what I mean. (Here you can't see but column B also has a note section and the picture there, thats why I need the macro with any column)

 

[Akos]

Anyone please?

 

[NdNoviceHlp]

Hi Akos. I suspect that the lack of replies is because "notes" are actually comments. If you google pictures in comments there's lots of stuff. Here's some sample code...

With Activesheet.Range("B" & 1)
        .AddComment
        .Comment.Text Text:="Picture Name:" & Chr(10) & ""
        .Comment.ShapeRange.Fill.UserPicture "C:\Users\Owner\Pictures\YourPictureFile.jpg"
End With

HTH. Dave

 

[Akos]

Hello Dave, thank you for reply, I was not very detailed about what i want. So basically I need a macro to insert pictures in comment to any column from Row2. (if its easier its ok with column "A" but pls tell me what should i modify in the code to make it work on another column)

The pictures are on my desktop here: C:\Users\szaboako\Desktop\Macro test

The pictures named exactly the same as the column value where I need the pictures in the comment. So firstly I think it needs to find the active column's value in the folder then insert the comment with the picture. (jpg/jpeg file)

It could be awesome, if the macro won't find in this folder the value, just simply goes to the next value in the column and continue the insert process
And i dont know if its possible, but I need the pictures compressed in "web" type (150ppi)

I hope you can help me, and sorry but i'm not so expert in macro codes.

 

[NdNoviceHlp]

Hi Akos. Where are the picture names (sht name, rows and columns)? What kind of pic files ie. JPG, Gif etc. ? Seems like it's possible to load the comments with pics. Do you want all the comments filled at once? I'm not familiar with what pictures compressed in "web" type means or if it can be done. Maybe others will be able to help with that. Dave