Notepad as Programming Text Editor

Friends, do you know that notepad serves as a HEX and Binary editor. Yes, it does. !!!

If you do not have an programming text editor or a Binary Editor then you can make many changes to system configuration files or make your own using notepad.

Now using a notepad will tell you how to format an HDD. Consider it one of the first steps in learning. But please use it only to make your repair/debugging work on your Windows System simpler, and not to infect others.

Steps for Drive formating using Notepad :

1) Copy The Following In Notepad Exactly as it says "Only 'Zero' and 'One' without space.
    01001011000111110010010101010101010000011111100000
2) Save file as an EXE.
3) It's Done.. Run the EXE to format the current partition.

Note : Do not try it on your PC. Don’t mess around with this is for educational purpose only. And please backup your data before experimenting.

Extracting text from a bunch of =EMBED(“Forms.HTML:Text.1”,“”) in Excel

Sub ExtractData()
Dim obj

    For Each obj In ActiveSheet.OLEObjects
        If obj.progID = "Forms.HTML:TextArea.1" Then
            me.Range("A1").Value = obj.Object.Value 
             ''' change the Range as required
        End If
    Next o
End Sub

SendKeys Method

This method places keystrokes in a key buffer. In some cases, you must call this method before you call the method that will use the keystrokes. For example, to send a password to a dialog box, you must call the SendKeys method before you display the dialog box.

The Keys argument can specify any single key or any key combined with ALT, CTRL, or SHIFT (or any combination of those keys). Each key is represented by one or more characters, such as "a" for the character a, or "{ENTER}" for the ENTER key.

To specify characters that aren't displayed when you press the corresponding key (for example, ENTER or TAB), use the codes listed in the following table. Each code in the table represents one key on the keyboard.

ey	Code
BACKSPACE	{BACKSPACE} or {BS}
BREAK	{BREAK}
CAPS LOCK	{CAPSLOCK}
CLEAR	{CLEAR}
DELETE or DEL	{DELETE} or {DEL}
DOWN ARROW	{DOWN}
END	{END}
ENTER (numeric keypad)	{ENTER}
ENTER	~ (tilde)
ESC	{ESCAPE} or {ESC}
HELP	{HELP}
HOME	{HOME}
INS	{INSERT}
LEFT ARROW	{LEFT}
NUM LOCK	{NUMLOCK}
PAGE DOWN	{PGDN}
PAGE UP	{PGUP}
RETURN	{RETURN}
RIGHT ARROW	{RIGHT}
SCROLL LOCK	{SCROLLLOCK}
TAB	{TAB}
UP ARROW	{UP}
F1 through F15	{F1} through {F15}

You can also specify keys combined with SHIFT and/or CTRL and/or ALT. To specify a key combined with another key or keys, use the following table.

To combine a key with	Precede the key code with
SHIFT	+ (plus sign)
CTRL	^ (caret)
ALT	% (percent sign)

Example

This example uses the SendKeys method to quit Microsoft Excel.

Application.SendKeys("%fx")

Reference: MSDN.Microsoft.Com