How to insert pictures into Excel?

[Former Member]

Hi, all

I want to insert pictures with hyperlinks into excel files. Could you give me some sample code of this function? The code used abap ole, to insert pictures into excel. ^ - ^ Thank you very much~~~

Voldemort.

[former_member181995]

Search with OLE-technique for Excel.

And refer:

[Former Member]

Hi, I had referred these code before, but it seems I still could not solve my problem...

I could not understand the line:

CALL METHOD OF gs_cells 'Select' = select.

Is it used for insert picture? It does not seems to be...

And in my program, the SY-SUBRC is 4 after run:

CALL METHOD OF gs_picture 'Insert'

EXPORTING

#1 = 'C:\TEMP\Picture.bmp'.

Of course my file path is correct, and the picture path is in my own coumputer rather than SAP server. Is that the problem?

[former_member181995]

This is for picture insert.

CALL METHOD OF gs_picture 'INSERT'

EXPORTING

#1 = 'C:\TEMP\Picture.bmp'.

[Former Member]

The sy-subrc still is 4. When I used this code...My file path is correct. And the file is in my own machine.