Wednesday, November 27, 2019

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

Wednesday, September 4, 2019

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

Thursday, May 2, 2019


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

Wednesday, February 27, 2019

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