MS Excel - Change Text from Lowercase to Uppercase using Excel Macro

Recently we had to convert all text in an excel file containing a list of books to uppercase. Here is an Excel macro to get this work done quickly.

Copy the code given below

Sub AllTextToUpper()
    Dim myRng As Range
    Dim celRng As Range
    On Error Resume Next
    Set myRng= Cells.SpecialCells(xlCellTypeConstants, 2)
    For Each celRng In myRng
        celRng.Value = UCase(celRng.Value)
    Next celRng 
End Sub

Open the Excel file and press Alt+F11 (Hold Alt key and then press F11). This will bring up Miscrosoft VBA editor. Paste the above code as shown in the image below.

• Close VBA Editor and come back to Excel (Or press Alt+F11 again)
• Now Press Alt+F8 (or Click View->Macros->View Macros). The following dialog box will be visible.

• Select AllTextToUpper and then Click Run
• All the text in your excel sheet will be converted to Uppercase

Note: Please save your original Excel sheet before running macros. This action cannot be reversed.

Anyflip - Convert your PDF into Flash & HTML5 flipbook Free

Anyflip.com provides you a free flipbook publishing platform to convert your PDF into an interactive, realistic Flash & HTML5 flipbook in minutes. It has got a free version and a pro version. The free version have certain limitations, but you will be able to create the flipbooks and publish them online free.

Now, let us see how to create a flipbook and to publish it on a blogger post.

• Visit http://anyflip.com and click on Create Account or you may login with your Google or Facebook account
• Once logged int, click on Quick Upload

Click on image to enlarge

• In the select version, select Flash and click OK
• Next, click on Upload your PDF button and select the PDF file (Your PDF must be less than 150 MB). You can add/modify the title, description, keywords and category here. Permission to download file and adding labels are available only for PRO version.
• You may also select a template from the Template tab, add toolbar and set the flash display settings on the Advanced Tab
• Depending on the file size uploading and converting may take some time, so please be patient.
• Once finished converting, your flipbook will be displayed as in the image below.

Click on the Embed button and you will be presented with four options - IFrame Embed, Lightbox Embed, Button Embed and Text Link. Click on IFrame Embed tab, if it is not already selected and set the size of the frame below.

• Now select and copy the code

Embed the Flipbook in Blogger Post

• Login to Blogger account and click on New Post
• Click on HTML button below the Post Title
• Paste the code copied from Anyflip inside the body and click on Publish button to publish the post.

How to Embed e-Newsletter on Blogger Using Scribd

The e-Newsletter created in MS Publisher can be embedded in a blogger post after uploading to scribd.com which is a popular open platform for publishing and sharing documents of all kinds.

Free Library Software for School Libraries

Library Automation - School Library Management Software

Effective management and utilisation of the library resources in an School Library requires incorporation of modern technologies as the Librarian alone has to do all the tasks in the library. This always causes delays in assisting the students to get the information they require as well as circulation of books to maximum number students in library periods alloted to the classes.

To facilitate the effective use of books the School Library has started computerisation with the Library Management Software developed in house by the Librarian. The software provides facilities for catalogue search, circulation of books and magazines, reservation of books, reports, class library management, fine collection, library statistics etc. Reports on the books issued, reservation status, search book by member and accession number, book suggestion and selection, budget expenditure and more for KV Libraries are available.

All the library resources are barcoded. Access to OPAC is provided through library websites (Intranet and Internet).

If you would like to try this free software for your library, you may download it from the link given below.

Snapshots of Library Software

Data Entry for Books

Circulation of Books

Issued Books Report

The library management software is free and may be downloaded from the link below.

Download

If you would like to use the software for your school library contact at kvklibrarian [at] gmail com with your details.

Please fill up the form for getting the download link. There will be four rar files. Download them all.