How to capture screenshots of a portion of computer screen at regular intervals

In this article we like to discuss on how to take screenshot of a portion of computer screen (Windows OS) at regular intervals automatically using freeware applications.

Screenshots of Full screen

To take screenshots of entire screen, there are a lot of applications. I suggest Fast Stone Capture v5.3 from here which is having a very small screen print. In addition, you can take screenshots of custom areas too with this application. It can also take screenshots of scrolling windows. The application size is only 1.06 MB and is portable (no installation required.). The following is the screenshot of the program.

FSC

If you want to take screenshots of entire screen automatically at intervals, I suggest auto screen capture from Sourceforge. You can get it from here. This is a small program (just 209 KB) but does a lot of things. This software is also portable. We can set the interval in hours/ minutes/ seconds/ milliseconds with this program. The program simultaneously records all the four windows screens (Don’t you know that in Windows OS you can have four screens?) and the active window separately.

You can either select a folder to save the screenshots or the program will create a folder images/screenshots in the program containing folder and store the screenshots there (default). Screenshots of all available screens will be saved in folders named 1 to 4 and active window  in a folder named 5 in that folder. The following image is the screenshot of the program.

Auto Screen capture

Screenshots of Portion of a screen at regular intervals

I noticed that Amazon.in has a page that describes 100 books to read in a lifetime. I wanted to make a list of the books with the image of the book. The images in the webpage could not be viewed as image if saved from the webpage. So I have to take screenshots for saving the images. I googled for a freeware software  for taking screenshots of portion of screen at regular intervals but I could not find a freeware for taking screenshot of a portion of the screen. But I found a workaround with two freeware programs – the first one for taking screenshots automatically at intervals and other for cropping all these screenshots at once in the preferred dimensions.

The first program is same as the program mentioned above – Auto Screen Capture with which we record the entire screen automatically at regular intervals.

The second program will crop these images as you specify. This freeware program is called JPEGCrops and can be download from here. This is also a small program and requires no installation. You need to open all images (JPEG format only), select the cropping method, Select ‘Syncronise Crop’ and then ‘Crop all images’. You will get the cropped images in ‘Cropped’ folder in C:\Users\user\Cropped directory (replace user with your username in the computer).

JPEG Crops.jpg

Steps to create screenshot of portion of your screen automatically

Step 1: Open Auto Screen Capture application, set the intervals and click on ‘start capture’>> JPEG. Click on the arrow on the right side of ‘Start Capture’ and select JPEG. (Please dont forget to select the image type as JPEG as JPEG crops will recognise only JPEG images).

Auto Screen capture - startcapture -jpeg.jpg

For my purpose, I set the interval as 3 seconds and scroll down the webpage periodically, kept each screen for 3 seconds so as to get the images at the same position in the screen.

Step 2: After all screens are captured, right click on the tray icon and select Stopcapture.

 

Step 3: Check the screenshots folder and delete the unnecessary screenshots.

JPEGCrops - SourceImage

Step 4: Open JPEGCrops and select screenshots by browsing to the folder containing the screenshots created using Auto Screen Capture. If you forgot to select the image type as JPEG while taking screenshots, don’t worry. Download FastStone Image viewer, another freeware, from here. It will help you batch convert the images to JPEG format.

Step 5: Select ‘Synchronise crops’ from Edit menu

JPEGcrops - synchronise crop

Step 6:  Select the dimension (or free if do not like to have any specific dimension) that you want to crop into from right click and ‘aspects’ menu

JPEGcrops - rightclick-aspects -free

Step 7: Now click on the picture and select the first cropped image and then click on ‘crop all images’.

JPEGCrops - crop as you wish

Check cropped folder to see the screenshots that you were looking for. If you want screenshots of other part of the screen, repeat steps 4-7.

Cropped output

Thank you for reading.

Have a nice day.

Day and Month gets interchanged on copying a date from Excel VBA userform to Excel Worksheet. Here is how to solve it.

The issue we discuss in this article is that when copying a date from Excel VBA userform and pasting to an Excel worksheet, the day and month keeps switching each other if the day is less than or equal to 12 (number of months). This reversal of day and month do not happen if the day is greater than 12 as this cannot be number specifying a month.

The issue

I encountered the same problem when I was making an application for my own calendar and to do app. The current user interface is shown below.

My To Do- UI

You may notice that I have three text boxes for entering dates viz.Entry date, Due date and Reminder date. I first used the following code to write the date to my Excel worksheet.

With Sheets("To do")
row_max = .Cells.Find(What:="*", after:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row + 1
.Cells(row_max, 2).NumberFormat = "dd-mm-yyyy"
.Cells(row_max, 2).Value = Format(tbEntryDate.Text, "dd-mm-yyyy")
End with

But this resulted in generating the following data in my worksheet. All the dates are entered for the month of May (05). It may be noticed that whenever the day number can denote a month (1 to 12) , the numbers corresponding to day and month are reversed in all the 10 cases.

My To Do - Date entry

This is due to the regional format setting where the Excel copies the date as MDY (“mm/dd/yyyy” or “mm-dd-yyyy” or other variants) US format from the Excel userform and I have kept the date format as DMY (“dd/mm/yyyy” or “dd-mm-yyyy” or other variants) which is mine (Indian) date format.

I searched the internet but I could not find a suitable solution. I have tried separating the day, month and year but still I could not figure it out.

The Solution

On the next day, I got an idea. I changed the month to Month name instead of month number. i.e. I used May for 05 while copying the date from the userform, as shown below.

With Sheets("To do")
 row_max = .Cells.Find(What:="*", after:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row + 1
.Cells(row_max, 2).Value = IIf(Len(tbEntryDate.Text) >= 8, Replace(Left(tbEntryDate.Text, 2), "-", "") & "-" & Application.WorksheetFunction.Choose(Replace(Left(Right(tbEntryDate.Text, 7), 3), "-", "") * 1, "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", ", Oct", "Nov", " Dec") & "-" & Right(tbEntryDate.Text, 4), "")
End with

I do explain the above code to you.

  • row_max is used to find the last unused row in the Excel worksheet.
  • the length of the date string can be as low 8 characters (eg.3-5-2017 ) in my case and hence I included the replace function to remove the “-” that may come if I do not ensure double digits for day and month.
  • The worksheet function “choose” is used to get the month name corresponding to the month number.

After this I do not find any issue with date formatting. I do not find the need to convert the date to the long date format/ single number.

How to reverse day and month in Multiple Dates

If you are having the same issue in your workbook where the imported dates show the month-day reversal for a range of entries, I have made an Excel VBA macro -Swap Month and Day in Dates – which is incorporated into the Excel VBA Addin – Jacros for Excel. More details can be obtained from jacrosforexcel.wordpress.com

Jacros for Excel - swap month and day

I Selected all these dates and applied the above tool from Jacros for Excel to the above dates. The old dates and the new changed dates are shown side by side below. The entire conversion completed at the blink of my eye!!!

Thank you for reading.

Have a nice day.

You can fix the stretched look of your computer screen. Here is how to do it.

How to fix the stretched look of your computer screen particularly after a fresh Windows installation

Operating systems can go corrupted over times of heavy usage. You need to backup your existing data, your existing program keys, etc. from the OS installed drive, atleast prior to the re-installation. It is quite time consuming to create your old features back when you reinstall the operating system and other applications. Equally distressing is that if you could not get the actual screen resolution and instead you get a bloated screen. Your icons, fonts, menu, … everything on the screen looks slightly stretched across and you do not feel good at seeing it. The same situation happened to me also. The Aero facility available in newer versions of Windows OS was also not working.

I have reinstalled Windows 7 (If you do not have the original DVD of installation media for your computer, you can get original installation files (ISO) for Windows 7,8.1 & 10 from Microsoft by providing the serial numbers. You can also download Microsoft office 2007 & 2010). No change in hardware. To get the original display resolution with the same monitor, I tried changing various display settings. But I could not make the screen resolution to the optimum resolution of the monitor (I have HP v185e Series wide screen LCD monitor that can show a screen resolution of 1366*768 pixels). But the operating system was showing other screen resolutions  like 800*600, 1024*768 , and then higher resolutions like 1600*1200 which cannot be shown on this monitor.

First I tried to get a driver for this monitor from the website of Hp but there is no change. After installation, I cannot find any trace of the installed driver in the display settings. A day gone without any clue. In the next day, I thought of making some Google search.

I searched on how to get resolution of 1366*768 in hp Monitor with Windows 7 OS. I got a clue that the graphics adapter has a role is setting the resolution. It indicated that you can find the graphics adapter/ driver in your system in ‘desktop right click>>screen resolution>>advanced settings’. I checked there. The Intel graphics adapter shown is different than what was there earlier. May be the new operating system could not identify the Intel Driver. I again searched and came across a picture that shows Intel(R) HD graphics. I remembered that I had some Intel applications running at startup, which might be this. So I need to identify the Intel adapter that I have.

So I searched for a reliable software for finding the correct graphics  driver in my system. I could not find such a software in Intel website, may be there, But I could not find. But I found that there is another software from them- to update the existing drivers in the computer. I thought of giving it a try. I installed ‘Intel® Driver Update Utility that keeps the system up-to-date, detecting which driver updates are relevant to the computer from http://www.intel.com/content/www/us/en/support/detect.html?iid=dc_iduu. The download was 9.42 MB.

The software was installed without any issues. I launched the program and clicked on ‘Start Scan’. It found one update for me. Since the software is from Intel, I trusted and gave it a try. The update was having a size of 83.30 MB for me. I installed the update and restarted as directed.

Intel update utility_compressed

Hurrey, to my surprice, the system shows the highest resolution of the monitor, which I was waiting for.

New resolutionAdapter recognised_compressed

Thanks Google and Intel for helping me to give my old screen resolution back. Here is how my screen looks like. I was not expecting this and hence I did not take screenshot of my earlier screen.

My new screen_compressed

If you also have the same issues, go to Intel® Driver Update Utility download page, download and instal the utility, get the update and enjoy.

Have a nice day.

Thank you for reading.

Another Neighbourhood Techie got 1,00,000 views!!! Thank you.

Another Neighbourhood Techie got 1,00,000 views!!!  Thank you.

100000 views

Thank you to all our visitors. We @ Another Neighbourhood Techie reached the ambitious milestone of one lakh (one hundred thousand) views. We never dreamed that  we could ever have such a great number of views. Your overwhelming response is well appreciated and we like to reward you with more posts. Thanks to WordPress for the good platform, Facebook, Twitter and Google+ for making us reaching out to our potential visitors (You).

The blog started in 2009 and we have one view. In 2010, we do not have a single post; we also do not have any views either. Views increased gradually. Last year, we have 62257 views. This year, when we reach 1,00,000 views, our views stand at 23,083. We also got our highest daily views of 297 this year.

We have published our latest blog status in May 10, 2016, when we stroke half century with blog articles. Now we have 65 posts excluding this.

Here is a graphical representation of our progress. Black line represents our progress. Red line represents your progress. (Chart plotted in Microsoft Excel).

ANT stats

We are committed to outshine our previous performance, i.e., to post more articles than that in previous year. We need your continued encouragement. Please visit us again and often.

We wish you a great time ahead.

Thank you once again.

Jackson & Anu

Dictate your notes in Android without using a dictation app

In the previous article – Dictate your notes in Android by using speech to text apps – we have discussed the various popular free apps that can be used to dictate notes on the go. Here in this article we will discuss how to dictate your notes in Android mobile without using a special dictation app and how to get it to your computer.

In short, the steps are as follows

1. Get the languages downloaded in Google Voice Typing
2. Create a new group in Whatsapp for storing the dictated text
3. Dictate the text as Whatsapp text and send it to the group
4. Open https://web.Whatsapp .com/ in computer and get the dictated text

1. Download the languages

• Open Settings >> Languages and Input >> Voice Search >>Languages. In some Android mobiles, you can find the setting here Settings >> Languages and Time >>Google Voice Typing>> Languages.
• Then select the appropriate language. If you are from India, Select English (India) from the list.
• Now select Settings >> Languages and Input >> Voice Search >>Offline Speech Recognition
• If you are from India, Select English (India)/ English (UK) from the list.
• You may enable Google Voice Typing keyboard also here.

2. Create a new group in Whatsapp

In Whatsapp, we cannot send messages to ourselves. So we need to send the dictated notes to somebody else so that we can access the notes in computer via https://web.Whatsapp .com/. A better alternative is to create a group having only one member – You !. Yes. The steps are the following.

• Create a new group in Whatsapp
• Add one of your friends who do not offend in seeing your group activity
• Click the Green Arrow Icon at the bottom. Add a suitable name and click the green tick symbol in the next screen to create your group
• Now open your group, long press on your friends name and select Remove
• Now you got your one person group

3. Dictate your text

Open Whatsapp. Select the group that you have created above. Press at the chat typing space. In the keyboard, press on the microphone symbol to start Google Voice Typing screen. Speak to the mobile when the microphone button is in green colour. If Android detects absence of speech for some time, it stops recording and types the text that you spoke. To start recording again, press the microphone button again. If you feel that Google typed something else for the words you spoke, you can delete using the backspace button on the screen. But you cannot edit in between. So edit on the go. You may not be able to add punctuation marks also here. Once your recording is over, just click on the send button.

4. Get the text in computer

This is the final step. Open https://web.whatsapp .com/. Make sure that your mobile is connected to the internet.

If you are using Whatsapp web version for the first time on your computer, you need to link your Whatsapp with the computer. Open Whatsapp. Press the three dot icon on the top right. Select Whatsapp web. Now focus your mobile camera to the QR code shown on the computer screen. If you have used Whatsapp web on other systems, tap the plus (+) button on the right to switch on the camera to scan the QR code on your present computer.

Now select the Group and copy the text to your word processor. Edit as per your requirement.

If you missed reading about free apps that can be used to dictate notes and store all arranged , please read our previous article – Dictate your notes in Android by using speech to text apps.

Thank you for reading. Have a nice day.

Dictate your notes in Android by using these free Speech-to-Text apps

There are several ways to dictate your notes. If you have a microphone, you can talk to your computer. Open your word processing software, just speak to add text. Speech recognition tools built into Windows 7/10 computers do the job for you. In addition, there are several online sites that provide speech to text facility. But if you do not have a mic, you cannot make use of the above facilities. This article discusses how to do dictation using your Android mobile and get the text in your computer. You can dictate either by using a specialized dictation app or without a dictation app. We got mixed results in testing these methods.

Dictating on your own is a good idea. Some of the advantages/benefits of dictation are given below.

  • Dictating your own note will improve your pronunciation and command in language.
  • Dictation make you better at explaining and expressing your thoughts and improve your creativity
  • Dictating notes will help you to improve the clarity and depth of your thoughts and it will help you become capable of making extempore speeches.

Part 1 of this article discusses about using speech to text apps to get the text. Part 2 of the article discusses about dictating your text without any specific speech to text apps.
We have tested four popular speech to text apps. We like to discuss the following free apps that we found easy to use. 

  1. Speech to Text Notepad
  2. ListNote
  3. Speechnotes

1. Speech to Text Notepad

By clicking on the new document button on the top right, you can start dictation. Sometimes the speech recogniser is trying to analyse background sound and will become busy in decoding that for a long time. On these times, click on the red microphone button once to switch off the microphone and then click on the blue microphone button to turn it on again. The app allows the use of code words like ‘period’ for “.”, ‘comma’ for “,”, ‘delete’ for deleting last word, ‘delete 5’ to delete last five words, etc. You have the option to save these recordings as text under various folders or share it to other apps.

The advantage we noted with Speech to Text Notepad is that it will not pause listening automatically during breaks (period when we stop speaking). We can speak with taking time gaps without touching the mobile. Hence this is our first favourite app for dictation.

2. ListNote

Our second favourite speech to text app is ListNote. Press the Big Blue ‘Speech Recognition’ button to start recording. The non-speaking time allowed between two consecutive speeches is 10 seconds which can be seen by the depleting bar just above the space for dictated text. If 10 seconds is over, you need to press ‘Continue speech’ to resume recording. If there is much delay to speak again, you can press the ‘Pause’ button alternatively. After dictation is over, click on ‘Done’. Long click on the dictated note in the list of notes, you will get a menu, take ‘share with’ to share the text with other apps.

3. Speechnotes

Speechnotes is the app we like place at third position. Click on the orange microphone button to start recording. It has a row with various symbols at the bottom that can be used to add punctuation marks. As in the case of the app we mentioned first, this app also records continuously and there is no time limit between two speeches. But we felt is that sometimes the app fails to record the words we speak. Click on the forward arrow button on top row to share the note with other apps.

The conversion of speech to text by the apps is affected by the sound in the recording background and the accent of our speech. We recommend a calm atmosphere with no background noice for perfect dictation.

The advantage using apps is that you can edit notes. Click on the place where you want to edit and a blinking curser will appear there. Delete text if required. Dictate further text as per your requirement.

But if you do not want to edit notes or you decide that you will edit the notes in the computer, there is no need to use special apps for dictation. We discuss about the same in the next article, which you can read from here- Dictate your notes in Android without using a dictation app.

Thank you for reading. Have a nice day.

How to type in Malayalam in Whatsapp from Windows 10 computer

In my previous two articles, we mentioned how to type in Malayalam in Whatsapp in your Android smartphone using Google Handwriting Input and using Swiftkey Keyboard. You can read these articles here and here respectively. In this article, we discuss about how to type in Malayalam in Whatsapp in your Windows 7 or 10 computer.

Step 1: Install necessary tools in Computer

The requirements in your Windows computer are the following.

Now let us set the tools for Malayalam in Google Input Tools. Click on the icon for Google Input Tools in the chrome on the right of address box above the bookmarks bar. Select ‘Extension Options’ from the menu.

google-input-tools-icon-in-chrome

Now from the list of languages on the left box (Add Input Tools), select ‘Malayalam’ and click on the right arrow to move it to the right pane (Selected Input Tools). Close the tab.

google-input-tools-select-malayalam

Click on the Google Input Tools icon in your chrome address bar and select Malayalam. See the images below – first one before selecting the Malayalam tool and the second after selecting the Malayalam tool. Note the change colour of ma in icon.

Step 2: Open web version of Whatsapp

In a new tab, type web.whatsapp.com in the address box and press Enter. Now you will get a webpage with a QR code, as shown below.

Open Whatsapp app in your mobile, click on the three dot icon on the top right  and select WhatsApp Web from the menu. Scan the QR code shown in the computer as shown in image above on the right. Immediately scanning the QR code, the web version of Whatsapp opens in your browser tab.

Step 3: Type your content

Now select the person/ group in the left pane to whom you want sent message in Malayalam. Type your message in the bottom box in the right pane in English letters like you are giving the text to a person who cannot read Malayalam language. 5-6 Suitable Malayalam words will be displayed below from which you can select the best Malayalam word by mouse or using arrows in the keyboard. If the first Malayalam word is correct after you press SPACEBAR, the text will be inserted into the message box automaticall and there is no need to specially select that.After entering the message, click on the send icon on the right bottom to send the text entered.

whatsapp-web-typing-in-malayalam

Congrats. You have successfully sent your Whatsapp Malayalam message from  your computer.

If you want to write in English, select the Google Input Tools icon and select ‘Turn off’ from the menu.

You can type not only in Whatsapp but also in other webpages  with this technique.

Similarly you can type in other Indian languages – Hindi, Kannada, Tamil, Bengali, Marathi, Punjabi, Gujarati, Bengali, Sanskrit, Oriya etc. and other languages like Arabic, French, German, Chinese etc. You just need to select the corresponding tool from Google Input Tools.

As mentioned in the beginning of this article, read how to type in Malayalam in Whatsapp in your Android Mobile click here (write your message using your finger on the screen) and here (touch the appropriate buttons in the keyboard).

Thank you for reading.

A Review of the book ‘Eat that frog’ and my learnings from it

“Do not wait: the time will never be ‘just right’. Start where you stand, and work whatever tools you may have at your command and better tools will be found as you go along.”

frog1The above quote is by Napolean Hill and is stated in the book Eat that Frog. Eat that Frog, a book written by Mr.Brian Tracy, that describe about 21 great ways to stop procrastinating and get more done in less time. The book is written in simple English and can be read in good flow. I completely read the 117 paged book in four stretches. It is more important that we should take notes as we read through each chapter.The points that struck my mind together with my learning from the book are given below.

  • Make two lists of things to do, if possible, in writing – one for personal, one for work
  • Grade them in the order of importance (importance to your career or important to your life.) Also consider the consequences of doing/ not doing the work on time. (Eq. V-vital, I – important, R-  recommended,   D- delegatable and E – eliminatable)
  • We procrastinate things when we feel that we are tired to difficult and voluminous tasks.
  • In order to avoid tiredness, we need to take short breaks, sleep adequately, exercise regularly, have controlled diet and have good meditation.
  • In order to see difficult and voluminous tasks, divide these tasks into small, easy and interesting easy sub-tasks.
  • Make clarity in all these small tasks
  • Before doing each of these task make a plan. Make a small diagram of your plan in paper or in mind. Various Inputs-Processes -Parts of output
  • Put deadlines for these tasks and stick to the deadlines
  • Remove distractions like e-mail, whatsapp messages, other distractions. Concentrate on the task and try to continue present task without any break until the flow breaks.
  • Make plan for tomorrow when the day ends today. This will help your mind to do part of these work to do in subconscious mind and you will amaze the speed at which you can complete each task in the list.
  • If you finds a task boring or very much embarrassing, allocate just 5 minutes each day for it. Once you start seeing the results, increase the duration slowly. Your success becomes an addiction and you will add once feather to your cap.
  • Most important one is do not delay your start. Start Now. Start with you most difficult task (the ugliest frog)

Before reading the book, I have only one list (for work) and my list contained the following.

Serial Number
Tick for items, if completed
Date of entry
To do item – Company & item description
Date of completion

eg.

1235. — 12/12/2016 ABC Company – send reminder  |13/12/16
1236.–12/12/2016 XYZ Inc. – Call the promoter and get update about the project
1237. — 13/12/2016 PQR Inc – Review Meeting – letter, attendance, background note
and so on

After reading the book, I have changed my list as follows. I have one list for personal work and one for office work. It contains the following. Date of entry is added on top.

Item Code
Serial Number
Tick for items, if completed
Importance indicated by colour of text (Red, Green, Blue & Black)
To do item description
Each action taken with date (added later)

eg.

12-12-16
ABC 1235 — Send reminder | sent 13/12
XYZ 1236 — Call & Get update
13-12-16
PQR 1237 — RM on 23/12 letter, attendance, bg. note | letter sent 14/12 |
and so on

I have two more lists for each day. The details included are just the following (no more repeating the entries)

Date
Serial numbers of items to be done on that day (at the end of the day, circle the entry if done. ) Every morning, I review these lists and start with the most important one.

eg.

13-12-16 | 1221, 1235, 1236, 1237
14-12-16 | 1236
and so on

Now I maintain the above list for a week. Slowly I make it into a month. At the end of each day, I replan the next day. I will add colors to this list as well soon to make it more meaningful.

The book is a good read. I am sure you will also gain if you practice the lessons mentioned in the book. You can buy the book from Amazon.in

I like to end this article with a quote of Sadhguru received in whatsapp.

“Do everything like it is the last thing you do. There is nothing to hold back, nothing to save for later.”

20 lesser known but best productive apps for Android

Your’s and mine Android phones have lots of apps. But we have not been using many of the apps. The reason may be the available apps are not efficient or you may be unaware of several useful apps.

Here we like to discuss about 20 best productive free apps (most of which may not be known to you), in the beginning of year 2017. The apps are listed not based on any priority. Click on the title or scan the QR code, to go to the app page in Google Playstore.

Here we go.

    1. Mathdroidqr-mathdroid

      Mathdroid is a special calculator app and have the capabilities of a scientific calculator. It has many built in functions also. The most important feature we liked in this app is that we can view all the previous calculations above saving our valuable time doing same calculation again and again.Moreover, we can edit previous calculations or alter the figures wherever required. The feature is similar to ‘speedcrunch‘ for windows.

    2. Convertpadqr-convertpad

      Convertpad is a unit conversion app. This app can convert units about 100 different types of categories. The main advantage of this unit converter is that when you change one unit, you can see the revised corresponding values of all units in the category.

    3. The Free Dictionaryqr-free-dictionary

      Though there are many free English dictionaries, we like ‘The Free Dictionary’ from www.thefreedictionary.com the most. The dictionary works in offline mode too. It is fast and easy to use. The main advantages, we feel are that all the different meanings (both noun, verb) are given with sample sentences and are easily comprehensible.

    4. Mail.ruqr-mail-ru

      In Mail.ru app, you can configure multiple e-mail accounts and you can switch them easily. It will show you your custom folders also and have good search facilities. It is easy to use and can mark a copy of the mail to your account also while composing a mail.

    5. Youcam snapqr-youcam-snap

      Youcam snap is similar to camscanner, Microsoft Lens etc. with which you can capture the image of a document and the app will automatically crop the image to the size of the document. Sometimes you have to manually adjust the image to cut as per your requirements. The advantages that we find in Youcam snap are that the app size is low, the captured image will be saved as jpg file automatically and the size of the app is less compared to other similar apps. You can configure size of the image from settings.

    6. Google Keepqr-google-keep

      Google Keep is a note application wherein you can add quicknotes, to-do lists, other lists etc. which will be synchronised on the web and can be accessed online at https://keep.google.com immediately. The advantage is that you can make entries using your computer online and on syncing, the same appear in your mobile app. The synced notes can be seen offline in your mobile. But the limitation is that the app is not suitable for creating journals as there is limitation to the number of characters per note.

    7. Simple notepadqr-simple-notepad

      Google keep is a good app to store your small notes. What differentiates Simple Notepad from Google Keep is that it can handle large quantity of text which Google keep cannot. The limitation of Simple Notepad are lack of synchronisation to the web. This app can be used for creating journals like diary, events, stories etc.

    8. Tape-a-talkqr-tape-a-talk

      Tape-a-talk is just another recording app which can record sound in the surroundings. The advantage with Tape-a-talk is that the app can do recording in the background without any notification message . After you start recording with the app, nobody will know that you are recording, from seeing your mobile screen. The drawback is that if you forgot to stop recording, it can fill the vacant space in your mobile with continuous recording.

    9. Solcalendarqr-sol-calendar

      Solcalendar is a calendar app which can be used to schedule your day. Solcalendar can sync with Google Calendar. Adding events is easy. You can create multiple reminders for a single entry. You can view your scheduled events as a list. You can add your to-do lists also.

    10. VLC Media Playerqr-vlc-media-player

      VLC Media Player helps you to watch videos/ Movies in fast / slow speed. If you want to take notes decrease the speed. If you are feeling bored, increase the speed. The app will list the video and audio in the device folders.

    11. WPS Office

      WPS office is one of the best office programs for Android. We like it most as this app displays Excel files, Word documents and qr-wpz-officepresentations in most readable and manageable way. It also allows editing these documents. It provides faster scrolling through excel sheets. The app size is small. The recent entries feature will help you to easily access the recent documents.

    12. Text FairyText fairy app android

      The Text-Fairy app is an offline OCR (Optical Character Recognition) app. This app will help you to extract text by taking photographs of your desired printed text. After taken the photograph and converted to text form, connect your mobile to your PC via USB. You can find the corresponding unformatted text in a txt file in the folder textfee in the mobile memory .

    13. Camcard

      Camcard can save the visiting cards you get from other people into your mobile in electronqr-camcardic form and eliminate the need to keep the card in physical form. Further, it can add the contact to your contact list also. If you don’t want to add a contact to the phone contacts, find the contact in your mobile’s contacts list and delete the particular entry.

    14. Offline browserqr-offline-browser

      Offline Browser help you to download your favourite and useful websites to your mobile which can be seen in offline mode. The main advantage we feel about this app is that you can download a tutorial website or online instructions for some work or when you want to view your own website offline.

    15. Drive Autosyncqr-drivesync

      Drive Autosync app can be used for syncing the Google Drive folder to your phone. After syncing the data, the files and folders in Google Drive can be accessed like any other folder. You can set specific interval fors syncing the drive contents.

    16. Storage Analyserstorage-analyser

      Storage Analyser will analyse the space usage in our phone – both System and Memory card- and will present the usage with various pie charts. It will also display the folders with maximum size. It also lists the biggest files in the phone. This will eliminate unnecessary files/ folders that took much space in our mobile phone.

    17. Super Backupqr-super-backup

      Super Backup app is helpful in creating backup of our contacts, sms messages, call records, apps etc. The app can send the backups as e-mail so that these details can be accessed even if we lose our phone.  Creating backups of contacts is helpful, when we change our mobile phones too. In addition, taking regular backups will help to keep good track of sms messages, call records etc.

    18. Xenderqr-xender

      Xender is a file sharing app among Android devices by using the wifi feature of Android devices. Huge files, folders and apps can be transferred at blazing speed between Android devices in seconds without incurring any cost to you.

    19. Line Launcherqr-line-launcher

      Line Launcher app will replace the default launcher in the Android mobile device. The features we like the most are feature to hide unimportant apps in the app drawer, increasing the number of app icons in the app dock in the home screen, etc. It also supports creating folder containing many app icons, sorting the app icons based on usage, sorting app icons alphabetically and usage of gestures to open apps. Read more.

    20. Wallpaper Changerqr-wallpaper-changer

      Wallpaper Changer app helps you to change your wallpaper at intervals or at every screen unlock. Folders containing image files can be chosen as the source directory in the settings.

Thank you for reading.

How to convert column numbers to alphabetical characters and vice versa in Microsoft Excel using VBA

How to convert column numbers to alphabetical characters/ column letter and vice versa in Microsoft Excel using VBA

This article is on how to get the alphabetical notation of columns from their numerical equivalents in Microsoft Excel using Visual Basic for Applications (VBA).

1. Get alphabetical notation of columns from their numerical equivalents

For example, if you give column number as 27, you will get “AA” , its alphabetical equivalent/ column letter.

While writing VBA codes, I have come across a situation where I need the alphabetical equivalent of column numbers.

Microsoft Excel from its 2007 version has increased the number of columns 16384 i.e. columns range from A to XFD. A alphabetical notation for a column can have one (e.g. A) to three (e.g. AAA) characters. So we need to find out a maximum of three characters. First letter from the left in a three character column number indicates the number of 26*26s in the column number. The second letter indicates the number of 26s not counted in first character. The last character indicates the remaining no. of characters in the column name.

The following VBA function will give the alphabetical equivalent on giving the column number as input.

Function colAlphabet(iCol As Integer)
   iterAlphabet = Int((iCol - 1) / 26)
   firstAlphabet = Int(IIf(iterAlphabet - 1 > 0, (iterAlphabet - 1) / 26, 0))
   ColAlphabet = IIf(firstAlphabet > 0, Chr(firstAlphabet + 64), "") & _
                 IIf(iterAlphabet - firstAlphabet * 26 > 0, _
                    Chr(iterAlphabet - firstAlphabet * 26 + 64), "") & _
                    Chr(iCol - iterAlphabet * 26 + 64)
End function

In this function, first the no. of iterations of full alphabets (26 characters) is calculated and stored into iterAlphabet. In the second step, the number of 26*26s found out and stored into firstAlphabet. Balance number of 26s found out by deducting the sum of firstAlphabet*26 from iterAlphabet. Balance number of alphabets which are short of a full alphabet (26 characters) is found out by deducting iterAlphabet*26 from original column number. In ASCII, A is 65 and Z is 90. Hence we add the number 64 to each number to get the ASCII equivalent of number in CAPITALS.

2. Get column number from its alphabetical notation/ column letter

If you give a text corresponding to a column (column letter), the function below will give you the corresponding number.

Function Col_no(ColAlpha As String)
     ColAlpha = UCase(ColAlpha)
     If Len(ColAlpha) = 3 Then
         Col_No = (Asc(Left(ColAlpha, 1)) - 64) * 26 * 26 + _
                  ((Asc(Mid(ColAlpha, 2, 1)) - 64) - 1) * 26 + _
                  Asc(Right(ColAlpha, 1)) - 64
     ElseIf Len(ColAlpha) = 2 Then
         Col_No = (Asc(Left(ColAlpha, 1)) - 64) * 26 + _
                  (Asc(Right(ColAlpha, 1)) - 64)
     Else
         Col_No = Asc(Right(ColAlpha, 1)) - 64
     End If
End function

Here all individual characters are extracted from the string representing the column. In a three letter column index, first the number 64 is deducted from each extracted character to remove the ASCII numbering. For example, ASCII number of A is 65 and when we subtract 64 from 65 we will get 1 for A. The first character (from left) is multiplied with 26*26, second number is multiplied with 26 and the last number is taken as is. All the three added together will give you the corresponding column number.

I have used these two macros in my Excel add-in Jacros for Excel for various purposes.

Thank you for reading.