Procedure to Update Galaxy Note N7000 with Official DDLP8 4.0.3 firmware:

• Download the DDLP8 4.0.3 Firmware Package & Odin from here to your computer. Once downloaded, extract the same and then open Odin in your computer.
• http://cdn.androidadvices.com/wp-content/uploads/2012/05/Odin3-v1.838.exe
• http://www.hotfile.com/dl/156601210/d18d7d5/N7000DDLP8_N7000ODDLP5_INU.zip.html

• Turn Off your device so that it can be entered in the Download Mode. Download mode can be entered by pressing  Volume Down Key + OK button, and holding both simultaneously press the Power Button. Now, a Warning message will be shown when you need to press the Volume Up key to continue entering the Download Mode.

• Connect your Galaxy Note to computer with the help of original USB cable while keeping the Odin application opened in your PC. Once the device is connected, you should see that the ID : COM section in your Odin turns Yellow which will indicate that all the drivers have been installed successfully.

Note: If the ID : COM section doesn’t turn Yellow, you need to check with two things which are mentioned below,
• Install the USB Drivers in your computer &
• Go to the Path “Settings > Wireless & Network > USB Settings” and ensure that “Samsung KIES” option is ticked before connecting the phone to the computer.
Up next click on “PDA” tab to select “N7000DDLP8_N7000ODDLP5_N7000DDLP4_HOME.tar.md5” and click on “Start” to start the process of firmware update.  As soon as the device is updated successfully, the Galaxy Note will be rebooted, now disconnect the device from computer and turn Off the device so that it can be then entered in the recovery mode.

• Recovery mode in Galaxy Note can be entered by pressing Volume Down Key + OK button, and holding both simultaneously press the Power Button. Now, a Warning message will be shown when you need to press the Volume Down key to continue entering the Recovery Mode.
• In recovery mode, select Wipe data/factory reset and also you need to select Wipe Cache partition and then reboot your device by selecting reboot system now with the help of Volume rocker keys.
• Note: At any point of time just in case if the process of firmware update gets stopped due to any reason, all you need to do is restart the process from the start by re inserting the battery.
• Congratulations, you have now successfully updated the Galaxy Note N7000 firmware with the latest DDLP8 version of ICS 4.0.3 Do share with us in the comments section just in case if you face any issues as we will try our level best to sort out the same.

Install Windows 7 from USB

This guide works 100% for Windows 7 and Windows 8 unlike most of the guides out there. I have seen many sites/blogs that have “Install Vista from USB guide” but either with incomplete steps or not working guide. I have also seen some guides that don’t’ use proper commands in this guide. After spending many hours I have come up with this 100% working guide to install Windows 7 and Windows 8 from USB flash drive.

I just did this method on one of my friends machine and installed Windows 7 and Windows 8 . The main advantage is that by using USB drive you will be able to install Windows 7 or Windows 8 in just 15 minutes. You can also use this bootable USB drive on friend’s computer who doesn’t have a DVD optical drive.

The method is very simple and you can use without any hassles. Needless to say that your motherboard should support USB Boot feature to make use of the bootable USB drive.

Requirements:

*USB Flash Drive (Minimum 4GB)

*Windows 7 or Windows 8 installation files.

Follow the below steps to create bootable Windows 7/Windows 8 USB drive using which you can install Windows 7 or Windows 8 easily.

Procedure:

1. Plug-in your USB flash drive to USB port and move all the contents from USB drive to a safe location on your system.

2. Open Command Prompt with admin rights. Use any of the below methods to open Command Prompt with admin rights.

*Type cmd in Start menu search box and hit Ctrl+ Shift+ Enter.

Or

*Go to Start menu > All programs > Accessories, right click on Command Prompt and select Run as administrator.

3. You need to know about the USB drive a little bit. Type in the following commands in the command prompt:

First type DISKPART and hit enter to see the below message.

Next type LIST DISK command and note down the Disk number (ex: Disk 1) of your USB flash drive. In the below screenshot my Flash Drive Disk no is Disk 1.

4. Next type all the below commands one by one. Here I assume that your disk drive no is “Disk 1”.If you have Disk 2 as your USB flash drive then use Disk 2.Refer the above step to confirm it.

So below are the commands you need to type and execute one by one:

SELECT DISK 1

CLEAN

CREATE PARTITION PRIMARY

SELECT PARTITION 1

ACTIVE

FORMAT FS=NTFS

(Format process may take few seconds)

ASSIGN

EXIT

Don’t close the command prompt as we need to execute one more command at the next step. Just minimize it.

5. Next insert your Windows7/Windows 8 DVD into the optical drive and check the drive letter of the DVD drive. In this guide I will assume that your DVD drive letter is “D” and USB drive letter is “H” (open my computer to know about it).

6. Maximize the minimized Command Prompt in the 4th step.Type  the following command now:

D: CD BOOT and hit enter.Where “D” is your DVD drive letter.

CD BOOT and hit enter to see the below message.

7. Type another command given below to update the USB drive with BOOTMGR compatible code.

BOOTSECT.EXE /NT60 H:

Where “H” is your USB drive letter. Once you enter the above command you will see the below message.

8. Copy your Windows 7 or Windows 8 DVD contents to the USB flash drive.

9. Your USB drive is ready to boot and install Windows 7 or Windows 8. Only thing you need to change the boot priority at the BIOS to USB from the HDD or CD ROM drive. I won’t explain it as it’s just the matter the changing the boot priority or enabling the USB boot option in the BIOS.

Note: If you are not able to boot after following this guide means you haven’t set the BIOS priority to USB. If you got any problem in following this guide feel free to ask questions by leaving comment.

Update on Jan 11, 2012: If you find this guide difficult to follow, please use the easy-to-use guide to create a bootable USB to install Windows 7  or Windows 8 using official tool.

This guide works 100% for Windows 8 as well. Make sure you follow all steps correctly and launch the Command Prompt with admin rights (as given in the guide) to avoid errors. Good luck!

Source: http://www.intowindows.com/how-to-install-windows-7vista-from-usb-drive-detailed-100-working-guide/

Code for Excel- Converting Numbers to Words

Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
    Dim Riyals, Halalas, Temp
    Dim DecimalPlace, Count
    ReDim Place(9) As String
    Place(2) = " Thousand "
    Place(3) = " Million "
    Place(4) = " Billion "
    Place(5) = " Trillion "
    ' String representation of amount.
    MyNumber = Trim(Str(MyNumber))
    ' Position of decimal place 0 if none.
    DecimalPlace = InStr(MyNumber, ".")
    ' Convert Halalas and set MyNumber to dollar amount.
    If DecimalPlace > 0 Then
        Halalas = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _
                  "00", 2))
        MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
    End If
    Count = 1
    Do While MyNumber <> ""
        Temp = GetHundreds(Right(MyNumber, 3))
        If Temp <> "" Then Riyals = Temp & Place(Count) & Riyals
        If Len(MyNumber) > 3 Then
            MyNumber = Left(MyNumber, Len(MyNumber) - 3)
        Else
            MyNumber = ""
        End If
        Count = Count + 1
    Loop
    Select Case Riyals
        Case ""
            Riyals = "No Riyals"
        Case "One"
            Riyals = "One Riyal"
         Case Else
            Riyals = Riyals & " Riyals"
    End Select
    Select Case Halalas
        Case ""
            Halalas = " and No Halalas"
        Case "One"
            Halalas = " and One Halala"
              Case Else
            Halalas = " and " & Halalas & " Halalas"
    End Select
    SpellNumber = Riyals & Halalas
End Function
     
' Converts a number from 100-999 into text
Function GetHundreds(ByVal MyNumber)
    Dim Result As String
    If Val(MyNumber) = 0 Then Exit Function
    MyNumber = Right("000" & MyNumber, 3)
    ' Convert the hundreds place.
    If Mid(MyNumber, 1, 1) <> "0" Then
        Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
    End If
    ' Convert the tens and ones place.
    If Mid(MyNumber, 2, 1) <> "0" Then
        Result = Result & GetTens(Mid(MyNumber, 2))
    Else
        Result = Result & GetDigit(Mid(MyNumber, 3))
    End If
    GetHundreds = Result
End Function
     
' Converts a number from 10 to 99 into text.
Function GetTens(TensText)
    Dim Result As String
    Result = ""           ' Null out the temporary function value.
    If Val(Left(TensText, 1)) = 1 Then   ' If value between 10-19...
        Select Case Val(TensText)
            Case 10: Result = "Ten"
            Case 11: Result = "Eleven"
            Case 12: Result = "Twelve"
            Case 13: Result = "Thirteen"
            Case 14: Result = "Fourteen"
            Case 15: Result = "Fifteen"
            Case 16: Result = "Sixteen"
            Case 17: Result = "Seventeen"
            Case 18: Result = "Eighteen"
            Case 19: Result = "Nineteen"
            Case Else
        End Select
    Else                                 ' If value between 20-99...
        Select Case Val(Left(TensText, 1))
            Case 2: Result = "Twenty "
            Case 3: Result = "Thirty "
            Case 4: Result = "Forty "
            Case 5: Result = "Fifty "
            Case 6: Result = "Sixty "
            Case 7: Result = "Seventy "
            Case 8: Result = "Eighty "
            Case 9: Result = "Ninety "
            Case Else
        End Select
        Result = Result & GetDigit _
            (Right(TensText, 1))  ' Retrieve ones place.
    End If
    GetTens = Result
End Function
   
' Converts a number from 1 to 9 into text.
Function GetDigit(Digit)
    Select Case Val(Digit)
        Case 1: GetDigit = "One"
        Case 2: GetDigit = "Two"
        Case 3: GetDigit = "Three"
        Case 4: GetDigit = "Four"
        Case 5: GetDigit = "Five"
        Case 6: GetDigit = "Six"
        Case 7: GetDigit = "Seven"
        Case 8: GetDigit = "Eight"
        Case 9: GetDigit = "Nine"
        Case Else: GetDigit = ""
    End Select
End Function

How to quickly create an empty add-in for excel 2007

How to quickly create an empty add-in for excel 2007

1. Save a blank workbook as a Excel Add-In (*.xlam) in your Add-In folder.
   I named it MyAddIn.xlam.
2. Click Office button.
3. Click "Excel options" button.
4. Click "Add-Ins" tab.
5. Select Excel Add-ins.
   
6. Click "Go..." button.
7. Click "Browse.." button.
8. Select MyAddIn.xlam.
9. Click OK.
10. Make sure MyAddIn is enabled in Add-In Manager.
    
11. Click OK.

Add custom functions to your personal add-in

1. Click "Developer" tab on the ribbon.
2. Double click on Myfunctions.xlam in project window.
3. Click "Insert" tab.
4. Click Module.
   
5. Copy and paste custom functions and macros to code window.