web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Insert an image as a c...

Microsoft Dynamics AX (Archived)

Insert an image as a comment in an Excel cell

(0) Share

Report

Report

Posted on by Abby Abraham

314

Does anyone know how to insert an image as a comment in an Excel cell?

I can add a text as a comment by using sysExcelCell.addcomment("Comment here") but it does not seem to support adding images as comments.

Thanks for your help.

Abby

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report

Does Excel support images in comments at all? I'm not aware of it.

Was this reply helpful? Yes No
Abby Abraham 314 on at

Like (0)

Report

Yes it does on Excel itself and

also C# code below

For Each cell In Selection

pic = "C:\pic.jpg"

With cell.AddComment

.Shape.Fill.UserPicture pic

End With

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report

Okay, I just don't know how to do it in Excel.

I suggest you follow a C# implementation, like this one. It creates a comment with empty text and then accesses its Shape property.

Was this reply helpful? Yes No
Verified answer

Abby Abraham 314 on at

Like (1)

Report

Got it working.

Here is the code I wrote

COM comment;

COM shape;

COM line;

COM userpic;

comment = sysExcelWorksheetBackOrder.cells().item(1,5).addComment("").comObject();

shapes = comment.shape();

line = Shapes.fill();

userpic = line.UserPicture("C:\temp\pic.jpg");

Thank you

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans