24/02/2016

[VBS]IE fill form and submit

Option Explicit
Dim ie, ipf

Set ie = CreateObject("InternetExplorer.Applicati­on")

On Error Resume Next

Sub WaitForLoad
Do While IE.Busy
WScript.Sleep 500
Loop
End Sub

Sub Find(x)
Set ipf = ie.Document.All.Item(x)
End Sub

ie.Left = 0
ie.Top = 0
ie.Toolbar = 0
ie.StatusBar = 0
ie.Height = 120
ie.Width = 1020
ie.Resizable = 0

ie.Navigate "https://www.facebook.com/"

Call WaitForLoad

ie.Visible = True

Call Find("email")
ipf.Value = "EMAIL GOES HERE"
Call Find("pass")
ipf.Value = "PASSWORD GOES HERE"
Call Find("login_form")
ipf.Submit

Call WaitForLoad
ie.Height = 700
________________________________________­______________

Know the Basics:
----------------------------------------­----------------------------------------­----------
Set ie = CreateObject("InternetExplorer.Applicati­on")

ie.Document.All.Item("INPUT ID").Value = "what you want"
ie.Document.All.Item("FORM ID).Submit
----------------------------------------­----------------------------------------­----------

22/02/2016

[JS]keycode

document.onkeydown = function(){
var x = event.keyCode;
        if(x==112){
            datamart_js();
}
}

f1 112
f2 113
f3 114
f4 115
f5 116
f6 117
f7 118
f8 119
f9 120
f10 121
f11 122
f12 123

13/02/2016

[SAS]Macro


options symbolgen mprint;


/*symbolgen -> macro variale ( ) resolves to ( )*/

/*mprint -> output is written to the SAS log:*/


options nosymbolgen nomprint;

07/02/2016

[SAS]Comment and fix error

/* '; * "; */;
quit;
run;


   *---------------------------------------*
   |  This uses one comment statement      |
   |           to draw a box.              |
   *---------------------------------------*;

[SAS]Proc SQL

proc sql; /* required */
create table mytable as select ...; /* 1 - new table */
create view myview as select ...; /* 2 - new view */
select ...; /* 3 - powerful query tool */
alter table mytable ...; /* 4 - new table structure */
update table mytable ...; /* 5 - update table content */
insert table mytable ...; /* 6 - update table content */
delete from table mytable ...; /* 7 - delete table content */
drop table mytable; /* 8 - delete table */
quit; /* required */

03/02/2016

[DOS command]Dan

@ECHO off

echo ████      ███    █       █
echo █    █    █     █   ██     █
echo █     █   █     █   █ █    █
echo █     █   █     █   █  █   █
echo █     █   █████  █   █  █
echo █     █   █     █   █    █ █
echo █    █    █     █   █     ██
echo ████    █     █   █       █

@PAUSE