Tech2 Touch

Author: Aniruddh

  • Password protecting Excel VBA macros

    We will be facing many circumstance where we need to password protect the excel VBA code we have written. Some times it may be for avoiding unintentional changes to the VBA codes or for hiding our codes from the others. Excel VBA provides a simple way to protect Excel VBA macro using password. This will not only protects from making changes also it protects the code from viewing. Lets start learning on how to password protect Excel VBA codes.

    Step to protect Excel VBA codes using password

    Below are steps to be followed to password protect the VBA codes.

    • First open VBA editor. Shortcut key for opening VBA editor is Alt+F11
    • Go to tools-> Select “VBA project Properties”
    • There new screen pops up. Select “Protection” Tab. You will get a screen similar to given below

    • Select the check box beside “Lock project for viewing” to hide the codes from viewing without password. If you do not want to hide the macro code and just want to protect your codes, then do not select the check box.
    • Enter the desired password in the “Password” labeled text box. Once again type the same password in the “confirmation password field “too.
    • You are done. Save the sheet and close the excel sheet.
    • Next time if you open VBA explorer you will prompted for password to view or modify the codes.

    This is method of password protecting of Excel VBA codes works on almost all current version of Excel.

  • Saving contacts in CSV format from Outlook 2010

    For back up the contacts or moving contacts, we require to export contacts from Outlook. One of the way is to save the contacts in Excel CSV format. Saving contacts of MS outlook 2010 in CSV formats has many advantages such as searching and ordering of contacts in Excel or Access. Even though Outlook 2010 supports, exporting of contacts in many formats such as Microsoft Access file or xls or csv.

    Due to different tool uses different formatting, .csv format comes more handy. It just takes the content and not the format. One more advantage of exporting contacts from Outlook in CSV format is, you can even import this contacts to your android smartphones. So we will learn how to export the contacts from Outlook and import them in to Microsoft excel.

    Steps to Export Outlook contacts as CSV file:.

    • Open the Outlook contacts for exporting and click on the “Contacts” field in the navigation field of the application.
    • Click Open the “File”  tab in the multi function bar and click on the function “Open” and “Import”
    • Select the option “Export to a file” and click on “Next”.
    • Mark the “Comma Separated Values(Windows)”  on the next page and again click on “Next”
    • Now select the contact folder and give “Next”
    • Select the target location where you want to save the CSV file
    • Click on “Next” and “Finish” to start the export

    Importing CSV format contacts to Excel:

    • In Excel  2010 click on “Data” Menu and then select “From Text” option
    • Select the CSV file which you have exported from Outlook and start the wizard for text conversion by pressing “Import”.
    • On the first page of the wizard, activate the option “Delimited”.
    • In second page remove Tick mark for “Tabular” and set it for “Comma”
    • Select next and Click on Finish.

    In Excel you format the contact in your desired way. You can delete duplicate contacts, merge contacts and perform many tasks which you might be already aware. For importing the contacts to gmail or Android phone, it has standard format. Just align the contents to according to standard format and import.

  • Micromax X1i Reloaded Price Specification Review

    Micromax X1i Reloaded is a basic Dual sim phone to meet basic communication needs. It has VGA camera and wireless FM radio with recording abilities.  The Micromax X1i Reloaded houses Li-ion 1800 mAh battery which offers max talk time of upto 6 hours and a standby time of 264 hours. This Micromax Dual SIM supports expandable memory upto 8GB.

    Summary of Micromax X1i Features

    0.3 MP Primary Camera

    • Dual SIM (GSM + GSM)
    • Alphanumeric Keypad
    • Wireless FM Radio with Recording
    • GPRS Enabled
    • Expandable Storage Capacity upto 8 GB

    Micromax X1i Reloaded Sales box content: Handset, Battery, Charger, Headset, User Manual, Warranty Card

    Micromax X1i Reloaded Specifications

    • Operating Freq:GSM – 900, 1800
    • Size:46 x 111 x 14.7 mm
    • Weight:91 g
    • Display screen Resolution:QCIF, 176 x 220 Pixels
    • rimary Camera:Yes, 0.3 Megapixel
    • Video Recording:Yes
    • Camera Features:Scene Mode, White Balance
    • Battery type:Li-Ion, 1800 mAh
    • Talktime:6 hrs
    • Standby Time:264 hrs
    • Expandable Memory Slot: microSD, upto 8 GB
    • GPRS:Yes
    • WAP:Yes
    • USB connectivity:Yes, Mini USB
    • Bluetooth:Yes
    • Audio Jack:3.5 mm
    • FM:Yes, with Recording
    • Music Player:Yes, Supports MP3, WAV
    • Video Player:Yes
    • Other Features:LED Flashlight, MMS Enabled, Call and SMS Blacklist, Sound Recoder, Organizer, Calendar, Tasks, Alarm Clock, World Clock, Schedule Power On and Off, English and Hindi Language Support, Wallpaper, Screensaver, Auto Redial, Reject Call by SMS, Privacy Protection, Mobile Tracker, Text Reader, Preloaded Games

    Cost of Micromax X1i Reloaded in India: Micromax X1i price in India is ₹1,420.

  • Nokia Lumia 710 Price-Nokia Windows Phone

    Nokia Lumia 710 is Windows phone from Nokia. It runs on Windows Phone 7.5 (Mango) OS. Nokia Lumia 710 sports 1.4GHz Qualcomm Scorpion Processor with 512MB of RAM and Adreno 205 GPU. Lumia 710 houses 1300 mAh battery to provide talk time upto 7 hours and 400 hours of standby time. Nokia Lumia 710 is compatible with PC suite called Zune software.

    Quick summary of Nokia Lumia 710 Windows Phone features

    :

    • Windows Phone 7.5 (Mango) OS
    • 5 MP Primary Camera
    • 3.7-inch TFT Capacitive Touchscreen
    • 1.4 GHz Scorpion Processor
    • 2G,3G, WiFi supported
    • 8GB internal memory

    Nokia Lumia 710 sales box content: Handset, Battery, Charger, Headset, Data Cable, User Guide, Product Information Guide.

    Nokia Lumia 710 Specification

    Operating Freq:GSM – 900, 1800, 1900; UMTS – 2100

    • OS:Windows Phone 7.5 (Mango)
    • Java:No
    • Processor:1.4 GHz Qualcomm Scorpion
    • Graphics:Adreno 205
    • Size:62.4 x 119 x 12.5 mm
    • Weight:125.5 g
    • Display:3.7 inch Capacitve touch screen
    • Screen resolution: WVGA, 480 x 800 Pixels
    • Display Features:Gorilla Glass Display, ClearBlack Display
    • Primary Camera:Yes, 5 Megapixel
    • Secondary Camera:No
    • Flash:LED
    • Video Recording:Yes, 1280 x 720, 30 fps
    • Battery Type:Li-Ion, 1300 mAh
    • Talktime:6 hrs (2G), 7 hrs (3G)
    • Standby Time:400 hrs (2G), 400 hrs (3G)
    • GPRS:Yes
    • Edge:Yes
    • 3G:Yes, 14.4 Mbps HSDPA; 5.76 Mbps HSUPA
    • Wifi:Yes, 802.11 b/g/n
    • WAP:Yes, v2
    • USB connectivity:Yes, micro USB, v2
    • GPS Support:Yes, A-GPS with Bing Maps, Nokia Maps
    • Bluetooth:Yes, v2.1, Supported Profiles (A2DP 1.2, AVCTP 1.0, AVCTP 1.3, AVDTP 1.0, AVDTP 1.2, AVRCP 1.0, GAP, GAVDP 1.2, HFP 1.5, HSP 1.1, IOP, L2CAP, PBAP 1.0, RFCOMM 1.0, SDP, EDR)
    • Audio Jack:3.5 mm
    • FM:Yes
    • Ringtone:MP3, WAV
    • Music Player:Yes, Supports MP3, eAAC+, WAV
    • Video Player:Yes, Supports H.263, ASF, H.264, AVI, MPEG-4, WMV 9, HD Video Playback
    • Sensors:3D Accelerometer, Proximity Sensor, Ambient Light Sensor, Digital Compass

    Cost of Nokia Lumia 710: Nokia Lumia 710 price in India is ₹15,499.

  • Samsung Chat 222 Price-Dual Sim Samsung Phone

    Samsung Chat 222 is a dual sim phone with qwerty keypad. E222 has VGA rear camera with video recording features. Connectivity options of this phone are GPRS,USB and Bluetooth. Samsung E222 houses 1000 mAh battery which provides a talk time upto 11 hours and 550 hours of standby time.

    Quick summary of Samsung Chat E222 Features

    0.3 MP primary rear Camera

    • Dual SIM (GSM + GSM)
    • 2.2-inch TFT Display
    • QWERTY Keypad
    • FM Radio with Recording
    • GPRS and EDGE Enabled
    • Expandable Storage Capacity of 8 GB

    Samsung E222 Sales box contents: Handset, Battery, Charger, Headset

    Samsung E222 Specification

    • Operating Freq:GSM – 850, 900, 1800, 1900
    • Java:Yes
    • Size:61.3 x 109.5 x 11.8 mm
    • Weight:90 g
    • Display: 2.2 inch TFT
    • Screen resolution:220*176
    • User Memory: 43MB
    • SMS Memory: 1,000 + SIM
    • Phone book entries: 1,000
    • External Memory: MicroSD (Up to 8GB)
    • Battery Type:Li-Ion, 1000 mAh
    • Talktime:11 hrs
    • Standby Time:550 hrs
    • GPRS:Yes, Class 10
    • WAP:Yes, v2
    • USB connectivity:Yes
    • Bluetooth:Yes, v2.1
    • Audio Jack:3.5 mm
    • FM:Yes, with Recording
    • Sound Enhancements:3D Sound Technology
    • Ringtone:MP3, 64 Polyphonic
    • Music Player:Yes, Supports MP3, eAAC+
    • Video Player:Yes, Supports MP4, H.264

    Cost of Samsung E222: Samsung E222 price in India is ₹3110.