SAP Script Run from Excel Macro - Save PDF from VF03How to run a PowerShell scriptGet just the filename from a path in a Bash scriptHow to get a password from a shell script without echoingSAP macro using VB scriptExcel Macro updates SAP ScriptCombining SAP scripts with Microsoft Excel MacrosSave PDF from SAPUpload from clipboard not working in VBA Exceldelay SAP until dialog window openSAP fails on 2nd iteration of loop
You've spoiled/damaged the card
Poisson distribution: why does time between events follow an exponential distribution?
What are they doing to this poor rocket?
What do we gain with higher order logics?
Comma Code - Ch. 4 Automate the Boring Stuff
Who operates delivery flights for commercial airlines?
Old black and white movie: glowing black rocks slowly turn you into stone upon touch
Avoiding cliches when writing gods
Why is Colorado so different politically from nearby states?
Convert camelCase and PascalCase to Title Case
Do I include animal companions when calculating difficulty of an encounter?
Do manufacturers try make their components as close to ideal ones as possible?
Linux tr to convert vertical text to horizontal
Incremental Ranges!
When writing an error prompt, should we end the sentence with a exclamation mark or a dot?
Diet Coke or water?
Short story written from alien perspective with this line: "It's too bright to look at, so they don't"
Why is the relationship between frequency and pitch exponential?
Is there any word or phrase for negative bearing?
What are the words for people who cause trouble believing they know better?
Bent spoke design wheels — feasible?
Is it OK to bring delicacies from hometown as tokens of gratitude for an out-of-town interview?
Java 8: How to convert String to Map<String,List<String>>?
In this example, which path would a monster affected by the Dissonant Whispers spell take?
SAP Script Run from Excel Macro - Save PDF from VF03
How to run a PowerShell scriptGet just the filename from a path in a Bash scriptHow to get a password from a shell script without echoingSAP macro using VB scriptExcel Macro updates SAP ScriptCombining SAP scripts with Microsoft Excel MacrosSave PDF from SAPUpload from clipboard not working in VBA Exceldelay SAP until dialog window openSAP fails on 2nd iteration of loop
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Hi,
I'm buidling a Macro to automate the download the PDF of an invoice from SAP. I've got it mostly figured out, but I always get stuck on WScript - Object required error.
Can someone help me?
Here's the code:
Private Sub CommandButton2_Click()
If Not IsObject(SAPguiAPP) Then
Set SAPguiAuto = GetObject("SAPGUI")
Set SAPguiAPP = SAPguiAuto.GetScriptingEngine
End If
If Not IsObject(Connection) Then
Set Connection = SAPguiAPP.Children(0)
End If
If Not IsObject(SAP_Session) Then
Set SAP_Session = Connection.Children(0)
End If
If IsObject(WScript) Then
WScript.ConnectObject SAP_Session, "on"
WScript.ConnectObject SAPguiAPP, "on"
End If
Set xclapp = GetObject(, "Excel.Application")
Set xclwbk = xclapp.Workbooks.Open("C:UsersPS1043272DesktopCNPDF.xlsm")
Set xclsht = xclwbk.Sheets("Sheet1")
For i = 2 To xclapp.ActiveCell.SpecialCells(11).Row
INVCN = xclsht.Cells(2, 1).Value
SAP_Session.FindById("wnd[0]").maximize
SAP_Session.FindById("wnd[0]/tbar[0]/okcd").Text = "/nvf03"
SAP_Session.FindById("wnd[0]").sendVKey 0
SAP_Session.FindById("wnd[0]/usr/ctxtVBRK-VBELN").Text = INVCN
SAP_Session.FindById("wnd[0]/mbar/menu[0]/menu[11]").Select
SAP_Session.FindById("wnd[1]").sendVKey 37
Set WshShell = CreateObject("WScript.Shell")
WshShell.AppActivate "Print Preview"
SAP_Session.FindById("wnd[0]/tbar[0]/okcd").Text = "pdf!"
SAP_Session.FindById("wnd[0]").sendVKey 0
WScript.Sleep 500
SAP_Session.FindById("wnd[1]/usr/cntlHTML/shellcont/shell").SetFocus
WScript.Sleep 250
WshShell.SendKeys "^+s"
WScript.Sleep 750
WshShell.SendKeys "%n"
WshShell.SendKeys "C:UsersPS1043272Desktop" & CStr(INVCN) & "teste.pdf"
WshShell.SendKeys "%s"
WScript.Sleep 500
Next
End Sub
I always get stuck on the first WScript.Sleep. anyone knows why?
when i run the macro it says "run-time Error 424: Object Required" and when i run the script on SAP I get the error "Object Required: WScript -"
Thanks
scripting sap
asked Mar 24 at 13:08
pedrofsgspedrofsgs
12
add a comment |
Hi,
I'm buidling a Macro to automate the download the PDF of an invoice from SAP. I've got it mostly figured out, but I always get stuck on WScript - Object required error.
Can someone help me?
Here's the code:
Private Sub CommandButton2_Click()
If Not IsObject(SAPguiAPP) Then
Set SAPguiAuto = GetObject("SAPGUI")
Set SAPguiAPP = SAPguiAuto.GetScriptingEngine
End If
If Not IsObject(Connection) Then
Set Connection = SAPguiAPP.Children(0)
End If
If Not IsObject(SAP_Session) Then
Set SAP_Session = Connection.Children(0)
End If
If IsObject(WScript) Then
WScript.ConnectObject SAP_Session, "on"
WScript.ConnectObject SAPguiAPP, "on"
End If
Set xclapp = GetObject(, "Excel.Application")
Set xclwbk = xclapp.Workbooks.Open("C:UsersPS1043272DesktopCNPDF.xlsm")
Set xclsht = xclwbk.Sheets("Sheet1")
For i = 2 To xclapp.ActiveCell.SpecialCells(11).Row
INVCN = xclsht.Cells(2, 1).Value
SAP_Session.FindById("wnd[0]").maximize
SAP_Session.FindById("wnd[0]/tbar[0]/okcd").Text = "/nvf03"
SAP_Session.FindById("wnd[0]").sendVKey 0
SAP_Session.FindById("wnd[0]/usr/ctxtVBRK-VBELN").Text = INVCN
SAP_Session.FindById("wnd[0]/mbar/menu[0]/menu[11]").Select
SAP_Session.FindById("wnd[1]").sendVKey 37
Set WshShell = CreateObject("WScript.Shell")
WshShell.AppActivate "Print Preview"
SAP_Session.FindById("wnd[0]/tbar[0]/okcd").Text = "pdf!"
SAP_Session.FindById("wnd[0]").sendVKey 0
WScript.Sleep 500
SAP_Session.FindById("wnd[1]/usr/cntlHTML/shellcont/shell").SetFocus
WScript.Sleep 250
WshShell.SendKeys "^+s"
WScript.Sleep 750
WshShell.SendKeys "%n"
WshShell.SendKeys "C:UsersPS1043272Desktop" & CStr(INVCN) & "teste.pdf"
WshShell.SendKeys "%s"
WScript.Sleep 500
Next
End Sub
I always get stuck on the first WScript.Sleep. anyone knows why?
when i run the macro it says "run-time Error 424: Object Required" and when i run the script on SAP I get the error "Object Required: WScript -"
Thanks
scripting sap
asked Mar 24 at 13:08
pedrofsgspedrofsgs
12
add a comment |
Hi,
I'm buidling a Macro to automate the download the PDF of an invoice from SAP. I've got it mostly figured out, but I always get stuck on WScript - Object required error.
Can someone help me?
Here's the code:
Private Sub CommandButton2_Click()
If Not IsObject(SAPguiAPP) Then
Set SAPguiAuto = GetObject("SAPGUI")
Set SAPguiAPP = SAPguiAuto.GetScriptingEngine
End If
If Not IsObject(Connection) Then
Set Connection = SAPguiAPP.Children(0)
End If
If Not IsObject(SAP_Session) Then
Set SAP_Session = Connection.Children(0)
End If
If IsObject(WScript) Then
WScript.ConnectObject SAP_Session, "on"
WScript.ConnectObject SAPguiAPP, "on"
End If
Set xclapp = GetObject(, "Excel.Application")
Set xclwbk = xclapp.Workbooks.Open("C:UsersPS1043272DesktopCNPDF.xlsm")
Set xclsht = xclwbk.Sheets("Sheet1")
For i = 2 To xclapp.ActiveCell.SpecialCells(11).Row
INVCN = xclsht.Cells(2, 1).Value
SAP_Session.FindById("wnd[0]").maximize
SAP_Session.FindById("wnd[0]/tbar[0]/okcd").Text = "/nvf03"
SAP_Session.FindById("wnd[0]").sendVKey 0
SAP_Session.FindById("wnd[0]/usr/ctxtVBRK-VBELN").Text = INVCN
SAP_Session.FindById("wnd[0]/mbar/menu[0]/menu[11]").Select
SAP_Session.FindById("wnd[1]").sendVKey 37
Set WshShell = CreateObject("WScript.Shell")
WshShell.AppActivate "Print Preview"
SAP_Session.FindById("wnd[0]/tbar[0]/okcd").Text = "pdf!"
SAP_Session.FindById("wnd[0]").sendVKey 0
WScript.Sleep 500
SAP_Session.FindById("wnd[1]/usr/cntlHTML/shellcont/shell").SetFocus
WScript.Sleep 250
WshShell.SendKeys "^+s"
WScript.Sleep 750
WshShell.SendKeys "%n"
WshShell.SendKeys "C:UsersPS1043272Desktop" & CStr(INVCN) & "teste.pdf"
WshShell.SendKeys "%s"
WScript.Sleep 500
Next
End Sub
I always get stuck on the first WScript.Sleep. anyone knows why?
when i run the macro it says "run-time Error 424: Object Required" and when i run the script on SAP I get the error "Object Required: WScript -"
Thanks
scripting sap
asked Mar 24 at 13:08
pedrofsgspedrofsgs
12
Hi,
I'm buidling a Macro to automate the download the PDF of an invoice from SAP. I've got it mostly figured out, but I always get stuck on WScript - Object required error.
Can someone help me?
Here's the code:
Private Sub CommandButton2_Click()
If Not IsObject(SAPguiAPP) Then
Set SAPguiAuto = GetObject("SAPGUI")
Set SAPguiAPP = SAPguiAuto.GetScriptingEngine
End If
If Not IsObject(Connection) Then
Set Connection = SAPguiAPP.Children(0)
End If
If Not IsObject(SAP_Session) Then
Set SAP_Session = Connection.Children(0)
End If
If IsObject(WScript) Then
WScript.ConnectObject SAP_Session, "on"
WScript.ConnectObject SAPguiAPP, "on"
End If
Set xclapp = GetObject(, "Excel.Application")
Set xclwbk = xclapp.Workbooks.Open("C:UsersPS1043272DesktopCNPDF.xlsm")
Set xclsht = xclwbk.Sheets("Sheet1")
For i = 2 To xclapp.ActiveCell.SpecialCells(11).Row
INVCN = xclsht.Cells(2, 1).Value
SAP_Session.FindById("wnd[0]").maximize
SAP_Session.FindById("wnd[0]/tbar[0]/okcd").Text = "/nvf03"
SAP_Session.FindById("wnd[0]").sendVKey 0
SAP_Session.FindById("wnd[0]/usr/ctxtVBRK-VBELN").Text = INVCN
SAP_Session.FindById("wnd[0]/mbar/menu[0]/menu[11]").Select
SAP_Session.FindById("wnd[1]").sendVKey 37
Set WshShell = CreateObject("WScript.Shell")
WshShell.AppActivate "Print Preview"
SAP_Session.FindById("wnd[0]/tbar[0]/okcd").Text = "pdf!"
SAP_Session.FindById("wnd[0]").sendVKey 0
WScript.Sleep 500
SAP_Session.FindById("wnd[1]/usr/cntlHTML/shellcont/shell").SetFocus
WScript.Sleep 250
WshShell.SendKeys "^+s"
WScript.Sleep 750
WshShell.SendKeys "%n"
WshShell.SendKeys "C:UsersPS1043272Desktop" & CStr(INVCN) & "teste.pdf"
WshShell.SendKeys "%s"
WScript.Sleep 500
Next
End Sub
I always get stuck on the first WScript.Sleep. anyone knows why?
when i run the macro it says "run-time Error 424: Object Required" and when i run the script on SAP I get the error "Object Required: WScript -"
Thanks
scripting sap
scripting sap
asked Mar 24 at 13:08
pedrofsgspedrofsgs
12
asked Mar 24 at 13:08
pedrofsgspedrofsgs
12
asked Mar 24 at 13:08
pedrofsgspedrofsgs
12
asked Mar 24 at 13:08
pedrofsgspedrofsgs
12
asked Mar 24 at 13:08
pedrofsgspedrofsgs
12
12
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55324121%2fsap-script-run-from-excel-macro-save-pdf-from-vf03%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55324121%2fsap-script-run-from-excel-macro-save-pdf-from-vf03%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
