$(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: false, vro: false, 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
0

How to save in desktop the PDF Attachment in VF03 via scripting?

Jul 06, 2017 at 01:33 PM

69

avatar image

Hi,

I wasn't able to completely save automatically the PDF attachment of in VF03.

This are my codes:

For i = 2 To objSheet.UsedRange.Rows.Count

objSheet.Cells(i, 2).Copy

session.findById("wnd[0]").resizeWorkingPane 105, 31, False
session.findById("wnd[0]/usr/ctxtVBRK-VBELN").Text = objSheet.Cells(i, 2).Value
session.findById("wnd[0]/usr/ctxtVBRK-VBELN").caretPosition = 10
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/titl/shellcont/shell").pressContextButton "%GOS_TOOLBOX"
session.findById("wnd[0]/titl/shellcont/shell").selectContextMenuItem "%GOS_VIEW_ATTA"
session.findById("wnd[1]/usr/cntlCONTAINER_0100/shellcont/shell").currentCellColumn = "BITM_DESCR"
session.findById("wnd[1]/usr/cntlCONTAINER_0100/shellcont/shell").selectedRows = "0"
session.findById("wnd[1]/usr/cntlCONTAINER_0100/shellcont/shell").pressToolbarButton "%ATTA_EXPORT"

session.findById("wnd[1]").Close
session.findById("wnd[0]").sendVKey 3

Next

What's happening is that it stops in the "Save as" window the I will manually input the file name then click "Save" then it will automatically go to the next one.

I hope that you could provide me the correct codes for it to save automatically in Desktop without manual effort.

Thank you! :)

ry3br.png (72.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Stefan Schnell
Jul 07, 2017 at 06:55 AM
0

Hello Ely,

if you disable in the SAP Logon the using of the native dialogs - you can find more information here - and you use the scripting mode...

... the export dialog should looks like this...

... and it should be possible to record your activities.

You can find an exmple also here.

Let us know your results.

Cheers
Stefan


export.jpg (58.6 kB)
export2.jpg (24.7 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Stefan,

I have a problem.

The scripting option of my SAP is different from your screenshot.

Please see screenshot.

0

The version of the SAP that I am using is 7.20 only. Is there a way to do it in this version?

0

Hello Ely,

no, this option exists since SAP GUI 7.30 PL 8. I recommend you to update to a newer version of SAP GUI for Windows.

Cheers
Stefan

0