$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: true, vro: true, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
avatar image
Former Member

SAP GUI Scripting trying to paste screenshot of SAP to excel sheet(HardcopyToMemory)

Dear Experts,

I have been trying to access the clipboard for screenshot of SAP copied through "session.findById("wnd[0]").HardcopyToMemory" and pasting the same in an Excel Sheet.

I have been trying the same for last two weeks unsuccessfully.

Requesting for your Kind help if someone have already addressed this issue.

Please let me know if i have to furnish some more details.. 😊

Regards,

Kumar Santharam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 07, 2014 at 09:03 PM

    Hello.

    Shortest way is copy Picture as file and insert into Excel from file. After this is done delete created file.

    With some smart code using shapes you can Position Pictures on sheet.

    Sub image_sap()
    If Not IsObject(Applic) Then
       Set SapGuiAuto = GetObject("SAPGUI")
       Set Applic = SapGuiAuto.GetScriptingEngine
    End If
    If Not IsObject(Connection) Then
       Set Connection = Applic.Children(0)
    End If
    If Not IsObject(session) Then
       Set session = Connection.Children(0)
    End If session.findById("wnd[0]").HardCopy "C:\tmp\test.jpg", 1
    ActiveWorkbook.ActiveSheet.Pictures.Insert "C:\tmp\test.jpg"
    Kill "C:\tmp\test.jpg" End Sub
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Holger Köhn

      Hi Holger,

      Thanks again for sheding some light on the 'HarcopyToMemory' code... 😉

      Have a Great day ahead,

      Kumar Santharam