Creating Hotspot in Laptop - Sharing internet from Laptop to Smartphone

Have you ever thought of  accessing internet from your laptop to smartphone?
Have you ever thought of you should carry your router everywhere to connect multiple devices like smartphone, tablet and laptop to internet.

If your answer is yes, we have solution for your problem. So keep on reading...
If your answer is no, it is great useful piece of information. So keep on reading..

If your able to create a hotspot in your laptop, you can share internet with other devices like smartphone, tablet, e-reader and other laptops. How cool, isn't it!

You can easily convert your laptop as virtual router by using so many software like Connectify, mhotspot, MyPublicWifi and etc.

Connectify is most stable and easy to use software but its paid software. In free version, hotspot stops at every 30 minutes.

MyPublicWifi is  free tool and it is very easy to use.Click here to get MyPublicWifi

You can even create hotspot in your PC by connecting Data Card.

Have a Great Holidays.

Spellnumber In Rupees In Excel

Spellnumber In Rupees In Excel

Following function convert ( Rupees in figure ) numeric value in a Microsoft Excel worksheet cell into its equivalent in (Rupees in Word ) English words.
e.g.  =SpellNumber(2450) will display as Rupees Two Thousand Four Hundred Fifty Only 

After copying following code, Enable macro and use above function.

How to create the sample function Called SpellNumber

1. Start Microsoft Excel.
2. Press ALT+F11 to start the Visual Basic Editor.
3. On the Insert menu, click Module.
4. Type the following code into the module sheet.

Function SpellNumber(amt As Variant) As Variant
Dim FIGURE As Variant
Dim LENFIG As Integer
Dim i As Integer
Dim WORDs(19) As String
Dim tens(9) As String
WORDs(1) = "One"
WORDs(2) = "Two"
WORDs(3) = "Three"
WORDs(4) = "Four"
WORDs(5) = "Five"
WORDs(6) = "Six"
WORDs(7) = "Seven"
WORDs(8) = "Eight"
WORDs(9) = "Nine"
WORDs(10) = "Ten"
WORDs(11) = "Eleven"
WORDs(12) = "Twelve"
WORDs(13) = "Thirteen"
WORDs(14) = "Fourteen"
WORDs(15) = "Fifteen"
WORDs(16) = "Sixteen"
WORDs(17) = "Seventeen"
WORDs(18) = "Eighteen"
WORDs(19) = "Nineteen"
tens(2) = "Twenty"
tens(3) = "Thirty"
tens(4) = "Fourty"
tens(5) = "Fifty"
tens(6) = "Sixty"
tens(7) = "Seventy"
tens(8) = "Eighty"
tens(9) = "Ninety"
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
FIGLEN = Len(FIGURE)
If FIGLEN < 12 Then
FIGURE = Space(12 - FIGLEN) & FIGURE
End If
If Val(Left(FIGURE, 9)) > 1 Then
SpellNumber = "Rupees "
ElseIf Val(Left(FIGURE, 9)) = 1 Then
SpellNumber = "Rupee "
End If
For i = 1 To 3
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
If i = 1 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Crore "
ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Lakh "
ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Thousand "
End If
FIGURE = Mid(FIGURE, 3)
Next i
If Val(Left(FIGURE, 1)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + " Hundred "
End If
FIGURE = Mid(FIGURE, 2)
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
FIGURE = Mid(FIGURE, 4)
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & " Paise "
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
End If
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & " Only "
End If
End Function

How To 'Fix Bootmgr Is Missing' In Windows Vista/7

How To 'Fix Bootmgr Is Missing' In Windows Vista/7

Ok we have all had this horrible error at some point in our life, yes the 'Bootmgr Is Missing' error but the good news is you do not have to worry about it being anything to do with Hardware Issues because it has nothing to do with that, and best of all this is an easy fix providing that your have a Windows Recovery or Installation DVD.
 

Right we have 2 methods here for Fixing this issue......

Step 1 - Is using Startup Repair sometimes this will Fix the Issue. Note: You may need to Run 3 - 4 Times.

Step 2 - Will always Fix this Issue as I have never seen it fail yet.

So..... 2 choices, you can do them both starting with step 1 or you can just go to step 2 and get fixed straight away. I am Just being honest by putting both options here for you 

Step 1

Ok first things first, dig out your Windows Installation DVD and pop it in the Drive and then Reboot your System.

Now Select your correct Language and Click on Next.........

 
 
Ok now here Click on 'Repair Your Computer'

 
 
Now it is searching for Windows Installations...........

Once it has finished searching.... 

• Make sure that the Top Option has been select 'Use recovery tools that can help fix problems starting Windows. Select an Operating System To Repair'.

• Highlight Your Windows Installation in the Window Box

Now Click on Next..........

 
 
Ok.... Now lets try to see if the 'Startup Repair' will Fix the 'Bootmgr Is Missing' Error first.

So Click on 'Startup Repair'..........

 
 
Now the Startup Repair is scanning your System for the Problem in question.

Sometimes the Startup Repair will not fix this problem but it is always worth a try!

 

 

Ok so no Joy with the 'Startup Repair'?

Don't panic the next step will Fix your problem for sure, it is just sometimes the Startup Repair will Fix this issue but not always so let's move on to Step 2.............

 

Step 2

Now Click on 'View advanced options for system recovery and support' to take us back to the 'System Recovery Options'

 
 
Ok now we are back at the 'System Recovery Options' Main Menu.

Now this time we are going to Select 'Command Prompt' so Click on 'Command Prompt'

 
 
Ok in the Command Prompt Window Type c: and 'Press Enter'

Now at the C:\ Type cd boot and then 'Press Enter'..........

 
 
Ok all good? If you Command Prompt Window looks like the one below then we are good 

Lets move onward........

 
 
Now at the C:\Boot Type in the Following Commands and 'Press Enter' after each and every command.

bootrec /FixMbr
bootrec /FixBoot
bootrec /RebuildBcd

 
 
bootrec /FixBoot

 
 
bootrec /RebuildBcd

 

Ok that it, all done.

Now you know how to Fix a 'Bootmgr Is Missing' Error!

As you can see from my results I didn't have any Issue in the first place but wanted to show you how to Fix the dreaded 'Bootmgr In Missing Error.

E- Security Tips From Cyber Crime Police

Guidelines for Online Banking - For more details please refer Online Banking

General Information:

• Don't delete harmful communications (emails, chat logs, posts etc). These may help provide vital information about the identity of the person behind these.

• Remember that all other internet users are strangers. You do not know who you are chatting with. 

• Be extremely careful about how you share personal information about yourself online. 

• Be extremely cautious about meeting online acquaintances in person. If you choose to meet, do so in a public place and take along a friend.

• Save all communications for evidence. Do not delete or alter them in any way. 

• Be aware of all e-mails and SMS from any stranger luring you with billion dollar lottery prize, jobs in UK and huge wealth.

• Be sure that your WI-FI Network secured, use a strong password.

• Never share your passwords with anyone. Change the password frequently using a combination of letters, numerical and special characters.

• Never forget to sign out of your email or any other accounts.

• Never reveal your personal information to any stranger in online chatting.

• Never make online transactions in unsecured sites. Watch for 'https' in the address bar.

• Never follow links to your banking website from another website or e-mail, type it yourself in the address bar.

• Never open spam mails as they contain either virus or spyware. Enable spam filters in your mail boxes.

• Never post sensitive information in social networking and marriage sites.

• Never be greedy for free downloads. They might infect your computers.

• Never let credit cards go out of your sight while paying.

• Never visit sites that contain pornography or terror links.

Suggestions for better security:

• Use strong passwords. Choose passwords that are difficult or impossible to guess. Give different passwords to all other accounts. 

• Make regular back-up of critical data. Back-up must be made atleast once in each day. Larger organizations should perform a full back-up weekly and incremental back-up every day. Atleast once in a month the back-up media should be verified.

• Use Antivirus software and update regularly. 

• Use a firewall. Firewalls are usually software products. They are essential for those who keep their computers online through the popular Broadband and cable modem connections. 

• Do not keep computers online when not in use. Either shut them off or physically disconnect them from Internet connection. 

• Do not open e-mail attachments from strangers, regardless of how enticing the subject line or attachment may be. Be suspicious of any unexpected e-mail attachment from someone you do know because it may have been sent without that person’s knowledge from an infected machine. Regularly download security patches from your software vendors. 

Children:

Do not give out identifying information such as Name, Home address, School Name or Telephone Number in a chat room. Do not send your photograph to anyone on the Net without first checking with your parents or guardians. Do not respond to messages or bulletin board items that are suggestive, obscene, belligerent or threatening. Never arrange a face-to-face meeting without telling parents or guardians. Remember that people online may not be who they seem to be.

Parents:

Use content filtering software's on your PC to protect children from pornography, gambling, hate speech, drugs and alcohol. There is also software to establish time controls for individual users (for example blocking usage after a particular time at night) and log surfing activities allowing parents to see which site the child has visited. Use this software to keep track of the activities of your children. 

E-Businesses Tips to Fight Fraud:

• Develop and publish a comprehensive privacy policy.

• Ensure your employees are trained on the policy and follow it. 

• Monitor the privacy policy and your compliance. 

• Only ask customers for information that is absolutely necessary to complete a transaction.

• Store only absolutely necessary data elements; once a payment is complete, there is no reason to maintain payment information in readable form. 

• Verify the payment system that you implement deletes temporary data files with payment records.

• Make certain server log files do not inadvertently store customer payment information.

• Limit employee access to payment systems and monitor those who have access to sensitive data or payment systems. 

• Use technology tuned for the Internet to detect potential fraud. 

• Follow up on suspicious transactions and immediately report any security breach or loss of computer systems to police.

Check this link for Bangalore Buses Routes and Platform Numbers

Check this link for  Bangalore Buses Routes and  Platform Numbers

 
http://travel2karnataka.com/bangalore_bus_routes.htm

Useful MS word tips in Formatting

Useful MS word tips in Formatting

• Shrinking a Document to Fit

If you've created a document and one or two lines spill over into a new page, you can use the "Shrink to Fit" feature to fit everything on the page. Choose File, Print Preview and click on the Shrink to Fit button.

• Removing Formatting for a Portion of Text

To quickly remove character formatting, such as bold, italic, or underline, and reset text back to the normal style, select the text and press Ctrl+Spacebar (Ctrl+Shift+Z also works). To reset paragraph formatting, such as tabs and indents, back to the normal style press Ctrl+Q.

• Toggle through CASE Changes

You can quickly change the case of text from Title to UPPER CASE to lower case by selecting the text and pressing Shift-F3. Each time you press Shift-F3, the case will change.

• Selecting Text in MS Word

To select a word, double-click the left mouse button on the word

To select a sentence, hold down CTRL and single-click the left mouse button on the sentence.

To select a line of text on the screen, single-click with the left mouse button in the left screen margin at the line you want to select.

To select a paragraph, triple-click the left mouse button in the paragraphs

To select the whole document, hold down CTRL and A, or triple-click the left mouse button in the left margin of the screen.

Put your Mouse in snooze mode: Beware of shoulder and wrist pain

Short keys for Microsoft outlook 2007 Basic Navigation

CTRL+1 Switch to Mail.

CTRL+2 Switch to Calendar.

CTRL+3 Switch to Contacts.

CTRL+4 Switch to Tasks.

CTRL+5 Switch to Notes.

CTRL+6 Switch to Folder List in Navigation Pane.

CTRL+7 Switch to Shortcuts.

CTRL+PERIOD Switch to next message (with message open).

CTRL+COMMA Switch to previous message (with message open).

F6 or CTRL+SHFT+TAB Move between the Navigation Pane, the main Outlook window, the Reading Pane, and the To-Do Bar.

TAB Move between the Outlook window, the smaller panes in the Navigation Pane, the Reading Pane, and the sections in the To-Do Bar.

Arrow keys Move around within the Navigation Pane.

CTRL+Y Go to a different folder.

F3 or CTRL+E Go to the Search box.

ALT+UP ARROW or CTRL+COMMA or ALT+PAGE UP In the Reading Pane, go to the previous message.

SPACEBAR In the Reading Pane, page down through text.

SHFT+SPACEBAR In the Reading Pane, page up through text.

SHFT+PLUS SIGN or MINUS SIGN, respectively Expand or collapse a group (with a group selected) in the Navigation Pane.

LEFT ARROW or RIGHT ARROW, respectively Collapse or expand a group in the e-mail message list.

Creation of items or files in Outlook:

CTRL+SHFT+A Create an appointment. CTRL+SHFT+C Create a contact.

CTRL+SHFT+L Create a distribution list. CTRL+SHFT+X Create a fax.

CTRL+SHFT+E Create a folder. CTRL+SHFT+J Create a Journal entry.

CTRL+SHFT+Q Create a meeting request. CTRL+SHFT+M Create a message.

CTRL+SHFT+N Create a note. CTRL+SHFT+H Create a new Microsoft Office document.

CTRL+SHFT+S Post to this folder. CTRL+T Post a reply in this folder.

CTRL+SHFT+P Create a Search Folder. CTRL+SHFT+K Create a task.

CTRL+SHFT+U Create a task request.