English Tenses

	Present
Indefinite	I eat Apple
Continues	I am eating Apple
Perfect	I have eaten Apple
Perfect Continues	I have been eating Apple
	Past
Indefinite	I ate Apple
Continues	I was eating Apple
Perfect	I had eaten Apple
Perfect Continues	I had been eating Apple
	Future
Indefinite	I shall eat Apple
Continues	I shall be eating Apple
Perfect	I shall have eaten Apple
Perfect Continues	I shall have been eating Apple
	Future in Past
Indefinite	I should eat Apple
Continues	I should be eating Apple
Perfect	I should have eaten Apple
Perfect Continues	I should have been eating Apple

SAP Auto Login Script

Set SapGui = GetObject("SAPGUI")

Set application = SapGui.GetScriptingEngine

Set connection = application.OpenConnection("System Name as per Logon Pad", True)

Set Session = connection.children(0)

session.findById("wnd[0]/usr/txtRSYST-MANDT").text = "ClientNumber"

session.findById("wnd[0]/usr/txtRSYST-BNAME").text = "UserName"

session.findById("wnd[0]/usr/pwdRSYST-BCODE").text = "Password"

session.findById("wnd[0]").sendVKey 0

sapgui/user_scripting	TRUE
sapgui/user_scripting_disable_recording	FALSE
sapgui/user_scripting_per_user	FALSE

VBA excel Macros info

To Find the Last Row.

Dim sht As Worksheet
Dim LastRow As Long
Set sht = ThisWorkbook.Worksheets("Sheet1")

LastRow = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row

 VBA to automatically determine what your column widths should be.  

https://www.thespreadsheetguru.com/the-code-vault/2014/3/25/vba-code-to-autofit-columns

GRC AC 10 - Create new mitigating control owners

GRC AC 10 - Create new mitigating control owners

Create User in SU01 in GRC

Run the user sync à Object Repository

NWBC à  Access Management/Setup à Access Control Owners à create an entry and select owner type

NWBCàMaster Data à OrganizationsàAssign user in Owner Tab

NWBC à Master Data à Mitigating Controls à Select & Open Control à Owners Tab à Add Row

VBA Excel Links

Delete Empty Row. 

checks entire row and if empty then delete

https://www.mrexcel.com/forum/excel-questions/901824-vba-delete-blank-rows-only.html

RDDIT076 - change released TR into Unreleased TR

change released TR into Unreleased TR 

SE38 --> RDDIT076