VBA AppActivate with SAP T-Code

[plwhittington]

I've written VBA code in Excel to (1)run some t-codes in SAP, (2)capture screenshots, and (3)paste in MS Word.

Everything works, but I have to hardcode the name of the SAP screen when it's time to switch focus from Excel to SAP in order to do the screen capture. I can hardcode every SAP Screen to capture in the code, but that is very tedious. I would like for the program to be able to get SAP to the correct screen, identify the screen name it is on, then use AppActivate to set the focus on that screen for screen capture.

Currently, I call the following code in a subroutine, which executes the SM35 T-code in SAP:

session.findbyId("wnd[0]").maximize
session.findbyId("wnd[0]/tbar[0]/okcd").Text = "/nsm35"
session.findbyId("wnd[0]").sendVKey 0
session.findbyId("wnd[0]/usr/subD1000_HEADER:SAPMSBDC_CC:1005/txtD0100-MAPN").Text = "FI_TRA*"
session.findbyId("wnd[0]/usr/subD1000_HEADER:SAPMSBDC_CC:1005/ctxtD0100-VON").Text = "11/10/2014"
session.findbyId("wnd[0]/usr/subD1000_HEADER:SAPMSBDC_CC:1005/ctxtD0100-BIS").Text = "11/10/2014"
session.findbyId("wnd[0]/usr/subD1000_HEADER:SAPMSBDC_CC:1005/txtD0100-CREATOR").Text = "*"
session.findbyId("wnd[0]/usr/subD1000_HEADER:SAPMSBDC_CC:1005/ctxtD0100-BIS").SetFocus
session.findbyId("wnd[0]/usr/subD1000_HEADER:SAPMSBDC_CC:1005/ctxtD0100-BIS").caretPosition = 10
session.findbyId("wnd[0]").sendVKey 0

once the code runs, the correct SAP screen is present, but not active. I can activate it by using the following code:

AppActivate "Batch Session: Input Overview"


"Batch Session: Input Overview" is the name of the Task in Windows Task Manager (not the process name). I need to be able to use a variable in place of it so I don't have to look up and hard code every screen in SAP.

Thanks for any help.

 

[RickXL]

Hi,

Sorry, but I didn't spot the actual question.

Using a variable with AppActivate should be easy. E.G: AppActivate myVariable
but I am guessing that is not the question.

If you are using SM35 then won't the current screen always be something like: "Batch Session: Input Overview"?
Or is it the screen that the SM35 processing creates that you are trying to find so that you can put it into an AppActivate command?
That may be difficult because your VBScript session in SAP only knows about the current session, I think.
But again, if you always run that script won't it always end up at the same screen?

I think you will need to supply some more info please.

Incidentally, I suspect that the SetFocus and caretPosition commands will not actually be required. They just tell SAP that you left the cursor in the "To" date field when you made your recording.

Out of interest, is there any reason why you use SM35 and not get the script to run the other transaction directly?

You certainly can populate variables in these scripts. I run mine from Excel so I can automate some repetitive tasks.

 

[plwhittington]

Sorry- it's difficult to explain this clearly.....
When running an SAP session, the screen name/caption changes, depending on which t-code you are using and what you are doing within it. Therefore, the only way to be able to use the AppActivate command is to know exactly what the caption is. However, it is always displayed in Task Manager, on the APPLICATIONS tab under the TASK column. I can find lots of code to show me the PROCESSES running, but that is not what I need.
In my code, VBA is calling SAP, executing some processes and ending on some screens (which I get screenshots of). I keep thinking there should be a way for VBA to know what screen it is on, even if I have to use an API call....
Hope this clears it up a little. Thanks for the help.

 

[RickXL]

Can you use the Session.ActiveWindow property?

 

[plwhittington]

trying Z=Session.ActiveWindow.Name and it returns the value "wnd[0]". I actually trying to set the focus on the SAP screen and the only way I know to do that is by using the AppActivate command. If there is another way to activate the SAP screen using the Session.ActiveWindow command, I'm open to suggestions. Thanks.

 

[plwhittington]

Just figured it out- Z = session.findById("wnd[0]").Text returns the Text Name of the session. Thanks again for the help.

 

[RickXL]

I'm glad you got it working.

Thanks for the feedback.

 

[Raptor6L]

Hi all

Years late, i know, but I thinks this relates to a problem I'm facing.

Just figured it out- Z = session.findById("wnd[0]").Text returns the Text Name of the session. Thanks again for the help.

plwhittington - did you figure out how to re-activate a SAP window so you can go back and forth between Excel and the one SAP window?

If so, could you share please? Like, as in a little macro that will reactivate "session.findById("wnd[0]")" so it will accept more input from Excel\VBA?


Thanks
Chris

 

[Chris Bernardin]

Hello Rapton6L, years late, i thinks to a problem, the solution is

DisplaySAP = session.findById("wnd[0]").Text
AppActivate DisplaySAP

 

[Raptor6L]

Thanks CB. Not quite how I got it done, but that way is probably the most correct way to do it.

I got it sorted with just AppActivate ("insert screen name here")
I found when you're running through a macro where it changes SAP transactions, the screen name remains the first transaction opened.
E.g. MMBE screen name is "Stock Overview". In the same macro if MMBE is changed to MN02, the windows screen name remains "Stock Overview", so AppActivate ("Stock Overview") successfully reactivates the SAP screen throughout the entire macro.

Cheers
Chris