Bringing SAP window to front with VBA.

Radoslaw Poprawski

Active Member
Joined
Jun 19, 2021
Messages
398
Office Version
  1. 365
Platform
  1. Windows
Hello,
Im working on some automation tool with VBA and SAP Scripting.
I have run into a small problem which is bringing sap window to foreground.

I tried those methods:
VBA Code:
    session.findById("wnd[0]").SetFocus
    session.findById("wnd[0]").maximize
    session.ActiveWindow.BringToFront

But none of them are bringing my 1 opened and set sap session window to front.
I need thos so I would have both sap window screenshot with system date & time.

Can any1 help with this topic?

Thank you.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
I realize this is not what you are asking for, but have you tried to connect to SAP using Power Query instead?

1670409201627.png
 
Upvote 0
We Have Sap S3 without SQL connection,
This option is for SAP Hana and not for SAP S3.
also This is for verification required, so It is a must do a screenshot for sap and system time,
So yes i tried to do it this way but due to policies and such and also sap S3 its not an option, not for what im trying to do.
 
Upvote 0

Forum statistics

Threads
1,223,892
Messages
6,175,236
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top