Wednesday, 1 March 2023

About


Thursday, 5 March 2015

Abstract URL from Hyperlink

Point No. 1:- First open new excel sheet.
  • First method:- press window+r-->write "excel" without double quote--> press enter.
  • Second method:- If any excel sheet already open simply press ctrl+n;
  • Third method:- press window key and type excel in search box.



Point No. 2:- Paste your hyperlink data into new sheet.

Point No. 3:- Press Alt+F11 to open Microsoft visual Basic.
Point No. 4:- Now go to insert main menu --> select module
Point No. 5:- A module page open. Paste below code in module

                Public Function URL(take_range As range) As String
                    On Error Resume Next
                    URL = take_range.Hyperlinks(1).Address
               End Function

Point No. 6:- Now run this program. There is 2 way to run microsoft visual basic program.
  • First way:- Go to main menu--> select run sub/UserForm.
  • Second way:- Simiply press F5.
   
     Point No. 7:- A Micros popup window open. Simiply close it and press Alt+Q
     Point No. 8:- Now back to your sheet and use URL() funtion as shown below.
     
     Point No. 9:- Then press enter and press Ctrl+D to duplicate function downward.

Notes:- You can do it with exist excel workbook (current excel) without create a new workbook. If you do it with exit excel workbook just start from point no 3.

Finish Tutorial....

How To Run A Java Program



  • First of all prepare source code file. I have one HelloPro.java file.
  • Open cmd Command. There is 2 way to open command prompt:-
    • First way:- Press WINDOW+R and type cmd then press ENTER.
    • Second way:- Press WINDOW key and type cmd in search box finnaly press ENTER.
  • Set your source file path. My source file (HelloPro.java) situated in desktop.

  • Set your java file path. There is 2 way to set path, first temporary and second is permanently. we have to set temporary path:- 

  • Now we have to compile java source file. This process give us .class extention class file.
  • Write:- javac HelloPro.java

  • If there is no any error in your source code compiler give you a HelloPro.java file.
  • Now we have to interpret our class file.
  • Write:- java HelloPro

  • If there is no runtime error then result shown by the interpreter.

Finish!

Wednesday, 25 February 2015

Difference between Compiler and Interpreter


Compiler

  • It execute entire program as input.
  • It genrate intermediate object code.
  • It take less time to execute condition statement. (Faster)
  • More memory require.
  • Error shown when entire code checked.
  • Program not need to compile every time to run program. It one time .obj file creator.
  • Example:- c, c++, java


 Interpreter

  • It execute line by line as input.
  • It does't intermediate object code.
  • It take more time to execute condition statement. (Slower)
  • Less memory required.
  • It terminate as soon as error accrued in line of program.
  • Program every time interpret whenever we have to run it.
  • Example:- Basic, Machine language, assembly language.
Next

Java SDK Versions



  • JDK Alpha and beta version 1995
  • JDK 1.0 (Oak)                     1996
  • JDK 1.1                  1997
  • J2SE 1.2 (Playground)    1998
  • J2SE 1.3 (Kestrel)   2000
  • J2SE 1.4 (Merlin)   2002
  • J2SE 5.0 (Tiger)          2004
  • Java SE 6 (Mustang) 2006
  • Java SE 7 (Dolphin) 2011
  • Java SE 8          2014


Code Name Explation 

Playground:    It is a field where children play
Kestrel:           It is a type of bird.
Merlin:             It is a type of bird.
Tiger:              Type of wild animal.
Mustang:        Type of animal.
Dolphin:          It is a water mammals.

 Note:- Joe Palrang create duke(animated character) the mascot for PDA (Persional data assistant)called as star7.