Prevent Autorun.inf Virus from running in your Computer

<b>Autorun.inf</b> is mostly used by hackers to run and spread malicious software or malwares and viruses in computers. Most people especially those who are not so familiar with this type of file are victimized.<br /> <br /> In my own experience when I was surfing the net in an Internet Cafe and plugged in my USB Drive to the PC I was using. I was there to do some research and surfing other stuffs without any problem. Later on when I went home and plugged in my USB Drive into my PC I've noticed that all folder's and documents on my USB were all gone but found out that those was just hidden.<br /> <br /> And when I was able to retrieve back all files and documents I've noticed this "<b>Autorun.inf</b>" folder in my USB. I tried to delete the folder but failed because it's having a read-only attribute.<br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> So here's what I did:<br /> 1.) Open "<span style="color: #38761d;"><b>Run</b></span>", type in "<span style="color: #38761d;"><b>cmd</b></span>". To open the command prompt window.<br /> 2.) In the Command Prompt window, type in the Drive letter of the USB removable drive followed with colon e.g. ( <span style="color: #38761d;"><b>E:</b></span> ). You can check the drive letter in "<b>My Computer</b>".<br /> 3.) Type in <span style="color: #38761d;"><b>attrib -r -h -s "Autorun.inf"</b><span style="color: black;">,</span><b> </b></span>to clear all attributes of the "Autorun.inf" file.<br /> 4.) Type in <span style="color: #38761d;"><b>erase Autorun.inf</b></span>, to completely delete the file.<br /> <br /> And that doesn't end there. <span style="color: #cc0000;"><i>To prevent hackers or other malwares putting this file into your machine we need to create a replica of the <b>autorun.inf</b> file</i>. </span><br /> To do this, we need to create a folder also named <span style="color: #cc0000;"><b>autorun.inf</b></span> and set read-only and hidden attribute and make sure and remember not to delete this folder by yourself. Otherwise, your USB drive might get infected by the autorun.inf virus again. <br /> <br /> 1.) In the command prompt window, type in <span style="color: #38761d;"><b>md autorun.inf </b></span>to create the directory or folder.<br /> 2.) Type in <span style="color: #38761d;"><b>attrib +r +h +s autorun.inf /s /d</b></span> , to set a read-only, hidden and system attribute of  the folder.<br /> <br /> <i><b>You can also do this on your local hard drives.</b></i><br /> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpLHy_b1gOHIqx396ovCCFB6wgpJqp5exh9WEfLavHM2LPBpc76ypdB7TUStZCA1z42nYjicpZnvStBCFDZ_MxzE_WQgi4pWBh6ol794Y4Oq_OOfBzWNng4X7gb8BnBNWvLeez2tHUfyM/s1600/Autorun.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpLHy_b1gOHIqx396ovCCFB6wgpJqp5exh9WEfLavHM2LPBpc76ypdB7TUStZCA1z42nYjicpZnvStBCFDZ_MxzE_WQgi4pWBh6ol794Y4Oq_OOfBzWNng4X7gb8BnBNWvLeez2tHUfyM/s320/Autorun.jpg" width="320" /></a>The purpose of doing this is that windows won't allow having a file with the same file name in one directory. So if malware's tries to put the autrorun.inf on your USB or hard drives, it will not be created because we already have the folder also named as autorun.inf. <br /> <br />

tips and tricks windows tricks Prevent Autorun.inf Virus from running in your Computer

Autorun.inf is mostly used by hackers to run and spread malicious software or malwares and viruses in computers. Most people especially tho...

Read more »

Tricks on how to set an image background of folders in Windows XP/Vista/7

<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLcHCc1cyEje4vniVnBq9EhGGHuvJe0Eea6HsawLMvK15QA_707IQbyHelYCY29oULvUn8_kz6ME19iXGscSUbG1MqLTKlF6Ho43hH1drx1ij7yIMbp7cKmXLFXH5VCAz6qXR9GrzHGEA/s1600/Folder+Background_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLcHCc1cyEje4vniVnBq9EhGGHuvJe0Eea6HsawLMvK15QA_707IQbyHelYCY29oULvUn8_kz6ME19iXGscSUbG1MqLTKlF6Ho43hH1drx1ij7yIMbp7cKmXLFXH5VCAz6qXR9GrzHGEA/s320/Folder+Background_2.png" width="320" /></a></div> Have you ever wanted to customize the background of any folders in Windows XP/Vista/7?<br /> <br /> This trick will allow you to add a custom image background on your personal folders.<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> 1.) Choose the folder you want to customize.<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOBfdbG-61V2-0NGvJ_fXBWID0sIGYsYyiTjGyjBeBBeatrW-LSTPFiwQ1O8AUpr-qC3f3-ElcAj77jnyGq-a6sfPODaiwUrgUh-yc4y6CrDakbRVcwar01Tx1rb2ogr88LJ7lFu0xT8Y/s1600/Address.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="20" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOBfdbG-61V2-0NGvJ_fXBWID0sIGYsYyiTjGyjBeBBeatrW-LSTPFiwQ1O8AUpr-qC3f3-ElcAj77jnyGq-a6sfPODaiwUrgUh-yc4y6CrDakbRVcwar01Tx1rb2ogr88LJ7lFu0xT8Y/s640/Address.png" width="640" /></a></div> 2.) Save the image you want to set as background in the folder. Or you may also use the image file in a specific location.<br /> 3.) Open <b>"Notepad"</b> and paste the code below then save as <b>"desktop.ini"</b> inside the folder.<br /> <blockquote class="tr_bq">     [{BE098140-A513-11D0-A3A4-00C04FD706EC}]<br />     iconarea_image=Mustang-Monster-HD-Wallpapers.jpg<br />     iconarea_text=3407871</blockquote> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZA9ADD1mFs2qpSTF3chyphenhyphenzQC1rIfzRTdeFh75KgFXhfz3H9-yun16LZ0UyXDn_FV3AySd-aVbBpzxjmnwILndgOWL7lz3hVC-D066ukLrCFEDRoAyiQMir_LiFBUL0EIVQs_tt_eqtYys/s1600/desktop.png" style="margin-left: 1em; margin-right: 1em;"></a> <br /> <b>*Note:</b> <i><span style="color: #38761d;">Make sure you type the exact location of the image file. If you save the image inside the folder then just type the filename and the exact image extension. </span></i><br /> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZA9ADD1mFs2qpSTF3chyphenhyphenzQC1rIfzRTdeFh75KgFXhfz3H9-yun16LZ0UyXDn_FV3AySd-aVbBpzxjmnwILndgOWL7lz3hVC-D066ukLrCFEDRoAyiQMir_LiFBUL0EIVQs_tt_eqtYys/s1600/desktop.png" style="margin-left: 1em; margin-right: 1em;"><img alt="desktop configuration settings" border="0" height="120" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZA9ADD1mFs2qpSTF3chyphenhyphenzQC1rIfzRTdeFh75KgFXhfz3H9-yun16LZ0UyXDn_FV3AySd-aVbBpzxjmnwILndgOWL7lz3hVC-D066ukLrCFEDRoAyiQMir_LiFBUL0EIVQs_tt_eqtYys/s640/desktop.png" title="desktop configuration settings" width="640" /></a> <br /> 4.) Open "<b>Run</b>" and type "<b>cmd</b>".<br /> 5.) Now, we're gonna <i>set the system file attribute</i> of the folder we want to customize.<br />     On the command prompt window, type <b><span style="color: #38761d;"><i>attrib +s "<<span style="color: #cc0000;">folder address</span>>" /s /d</i></span></b> then press <b>Enter</b>.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLub004eZnh7w70DjaX60L-b5QEwjCkI7rGznjd95y9JFhrpqUt-PpRfzjrdm-ptSCrAaEcx2H1jKS2h4nAW-nrp7sOpO0KZmngAgqVOCagKMDD_kraWOg4QiboTyM3kH8zBY-3Sqahxc/s1600/set+system+attribute.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="114" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLub004eZnh7w70DjaX60L-b5QEwjCkI7rGznjd95y9JFhrpqUt-PpRfzjrdm-ptSCrAaEcx2H1jKS2h4nAW-nrp7sOpO0KZmngAgqVOCagKMDD_kraWOg4QiboTyM3kH8zBY-3Sqahxc/s640/set+system+attribute.png" width="640" /></a></div> 6.) Navigate to the folder and hit Refresh.<br /> <br /> <span style="color: #f1c232;"><span style="font-family: "Trebuchet MS",sans-serif;"><b>That's it! You've got it! Enjoy!</b></span></span></div>

hot tips and tricks Tricks on how to set an image background of folders in Windows XP/Vista/7

Have you ever wanted to customize the background of any folders in Windows XP/Vista/7? This trick will allow you to add a custom imag...

Read more »

Excel VLOOKUP Function Tutorial

The following example will give you an idea on how to use VLOOKUP in Microsoft Excel. If you're working with an excel database and want it to be dynamic the VLOOKUP/HLOOKUP functions are very useful for you. The VLOOKUP function looks up value in columns while HLOOKUP does in rows.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><br /> This example has two sheets "Price_List" and "Orders" for mobile brands. <br />*Note: The values given are not the actual market prices.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAaUwpgXip2lpnrGqQk5y0ovNoMC_OsNhD1N3c3amsg723hztYOOHeTgTvTuv0SxeR3qdUyhxHvi8xLawL9NIBCpXOrqx7i1Gq30nqCzEMPklCojFoJQ2BBXco4ObF4EoS8Dkv5URGCZ4/s1600/price+list.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAaUwpgXip2lpnrGqQk5y0ovNoMC_OsNhD1N3c3amsg723hztYOOHeTgTvTuv0SxeR3qdUyhxHvi8xLawL9NIBCpXOrqx7i1Gq30nqCzEMPklCojFoJQ2BBXco4ObF4EoS8Dkv5URGCZ4/s400/price+list.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s1600/lookup_formula.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a></div>The "Price_List" sheet has three columns ID, Model and Price. This is where we'll be looking up the prices value for every orders made.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s1600/lookup_formula.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="90" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s400/lookup_formula.png" width="400" /></a></div><br />Now, on the orders tab we have 3 orders made. We'll add the VLOOKUP function in the Total Price formula. This formula <span style="color: #6fa8dc;"><b>"=VLOOKUP(B2,Price_List!B1:C7,2,FALSE)"</b></span> will LOOKUP for the price of the unit brand in the Price_List Sheet.<br /><br /><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLC_lhA3IWlkoDDx4dpXMsJULiULifKw7jwP1-TRipusYU3EA0m7eNjE1DU-0Y29sCJ-eCpVhXjJa1lfXwU5_EV8LaRkZ-t3yXYTMYD8e8zVomi9Qe3fc3lkkpcBxiMEbMMVuNodjK9YQ/s1600/Total+the+price+with+the+quantity.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLC_lhA3IWlkoDDx4dpXMsJULiULifKw7jwP1-TRipusYU3EA0m7eNjE1DU-0Y29sCJ-eCpVhXjJa1lfXwU5_EV8LaRkZ-t3yXYTMYD8e8zVomi9Qe3fc3lkkpcBxiMEbMMVuNodjK9YQ/s1600/Total+the+price+with+the+quantity.png" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><span style="color: #9fc5e8; font-size: x-small;"><b>=IF(C2<>"",VLOOKUP(B2,Price_List!B1:C7,2,FALSE) *C2,VLOOKUP(B2,Price_List!B1:C7,2,FALSE))</b></span></td></tr></tbody></table><span style="font-size: small;">The formula above is a </span><i>logical condition</i> to calculate the <b>Total Price</b> when the quantity is entered.<br /><i>The condition is:</i><br /><blockquote class="tr_bq">If the quantity <b>"C2"</b> is blank then it will just <b>lookup the unit price from the Price_List Sheet</b>. And if the quantity is entered it will <b>calculate by multiplying the unit price with the quantity value</b>.</blockquote><br />

excel Excel VLookup Tutorial microsoft excel Excel VLOOKUP Function Tutorial

The following example will give you an idea on how to use VLOOKUP in Microsoft Excel. If you're working with an excel database and want ...

Read more »

How to use the VLOOKUP Function in Microsoft Excel

The following example will give you an idea on how to use VLOOKUP in Microsoft Excel. If you're working with an excel database and want it to be dynamic the VLOOKUP/HLOOKUP functions are very useful for you. The VLOOKUP function looks up value in columns while HLOOKUP does in rows.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <br />  This example has two sheets "Price_List" and "Orders" for mobile brands. <br /> *Note: The values given are not the actual market prices.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAaUwpgXip2lpnrGqQk5y0ovNoMC_OsNhD1N3c3amsg723hztYOOHeTgTvTuv0SxeR3qdUyhxHvi8xLawL9NIBCpXOrqx7i1Gq30nqCzEMPklCojFoJQ2BBXco4ObF4EoS8Dkv5URGCZ4/s1600/price+list.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAaUwpgXip2lpnrGqQk5y0ovNoMC_OsNhD1N3c3amsg723hztYOOHeTgTvTuv0SxeR3qdUyhxHvi8xLawL9NIBCpXOrqx7i1Gq30nqCzEMPklCojFoJQ2BBXco4ObF4EoS8Dkv5URGCZ4/s400/price+list.png" width="400" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s1600/lookup_formula.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a></div> The "Price_List" sheet has three columns ID, Model and Price. This is where we'll be looking up the prices value for every orders made.<br /> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s1600/lookup_formula.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="90" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDFgj48DCoj4vk6uQC3HoeX97ZjzoC2B7FPCTjuQIyRYjIWqJd5uKP9GrTBRB4s04JKmnGmamrd1ImnJ_ZwgZ0vEUCiST584NOgbgb0rb35RR0HLHa4k7JalfLingGSAUFMvWTNFOfVR0/s400/lookup_formula.png" width="400" /></a></div> <br /> Now, on the orders tab we have 3 orders made. We'll add the VLOOKUP function in the Total Price formula. This formula <span style="color: #6fa8dc;"><b>"=VLOOKUP(B2,Price_List!B1:C7,2,FALSE)"</b></span> will LOOKUP for the price of the unit brand in the Price_List Sheet.<br /> <br /> <table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody> <tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLC_lhA3IWlkoDDx4dpXMsJULiULifKw7jwP1-TRipusYU3EA0m7eNjE1DU-0Y29sCJ-eCpVhXjJa1lfXwU5_EV8LaRkZ-t3yXYTMYD8e8zVomi9Qe3fc3lkkpcBxiMEbMMVuNodjK9YQ/s1600/Total+the+price+with+the+quantity.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLC_lhA3IWlkoDDx4dpXMsJULiULifKw7jwP1-TRipusYU3EA0m7eNjE1DU-0Y29sCJ-eCpVhXjJa1lfXwU5_EV8LaRkZ-t3yXYTMYD8e8zVomi9Qe3fc3lkkpcBxiMEbMMVuNodjK9YQ/s1600/Total+the+price+with+the+quantity.png" /></a></td></tr> <tr><td class="tr-caption" style="text-align: center;"><span style="color: #9fc5e8; font-size: x-small;"><b>=IF(C2<>"",VLOOKUP(B2,Price_List!B1:C7,2,FALSE) *C2,VLOOKUP(B2,Price_List!B1:C7,2,FALSE))</b></span></td></tr> </tbody></table> <span style="font-size: small;">The formula above is a </span><i>logical condition</i> to calculate the <b>Total Price</b> when the quantity is entered.<br /> <i>The condition is:</i><br /> <blockquote class="tr_bq"> If the quantity <b>"C2"</b> is blank then it will just <b>lookup the unit price from the Price_List Sheet</b>. And if the quantity is entered it will <b>calculate by multiplying the unit price with the quantity value</b>.</blockquote> <br />

excel microsoft excel VLookup Function How to use the VLOOKUP Function in Microsoft Excel

The following example will give you an idea on how to use VLOOKUP in Microsoft Excel. If you're working with an excel database and want ...

Read more »

Keyascii Code Generator in VB6

<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4xAzOm0dcrw-kQVvTX8WQYmltnMw51B7CZnhuzXGkZQE5_cE8_Gosl7vO_UHicIi2Ey4TpySqVXAmlG9rLtWMAIdYMHQV8eXojLoJ0x0QyUCDeNdMIOWuGNezf1l2AzIuFvwZYUAC2pk/s1600/keyascii+code+generator+omelsoft.blogspot.com.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4xAzOm0dcrw-kQVvTX8WQYmltnMw51B7CZnhuzXGkZQE5_cE8_Gosl7vO_UHicIi2Ey4TpySqVXAmlG9rLtWMAIdYMHQV8eXojLoJ0x0QyUCDeNdMIOWuGNezf1l2AzIuFvwZYUAC2pk/s1600/keyascii+code+generator+omelsoft.blogspot.com.jpg" /></a></div> This application allows you get the equivalent KeyAscii Value for every key you'll press on your keyboard.<br /> <br /> Just click on the <b>"Change Me!"</b> and start pressing any key on your keyboard.<br /> The <b>Character Box</b> will display the key you just pressed.<br /> And the <b>ASCII Code</b> box will display the keyascii value of the key you pressed.<br /> <br /> Download the <a href="https://docs.google.com/file/d/0B0iwfClwecjZNThRcXZocHc1UDQ/edit?usp=sharing" target="_blank"><b>KeyAscii Code Generator</b></a> sample program. </div>

hot VB6 Keyascii Code Generator in VB6

This application allows you get the equivalent KeyAscii Value for every key you'll press on your keyboard. Just click on the "...

Read more »