Category Archive: CodeBase

Jul
26
2013

How to Convert Select Excel Cells into Comma Separated Values (CSV) with VBA

Here is a simple yet powerful technique to convert selected cell values (rows or columns or mix of cells) into comma separated values (CSV) or delimited text format with the help of VBA. This will be useful when you want to merge cell values together quickly (from a key board shortcut for example) and use …

Continue reading »

Jun
25
2013

ASP.NET/C# Ajax request replaces the whole page issue

Ajax functionalities becoming so important now a days as rich applications grows on web and consumers always prefer better performing websites and web apps. ASP.NET modern MVC framework designed to well utilize the ajax capabilities. Not a big expert in .NET/C#, I always prefer to start with a default MVC template from the visual studio …

Continue reading »

Jun
16
2013

How to get the PDF page count only with JavaScript

I have been busy for a while and could not dedicate much time into my blog. But here I am back with a ‘big bang’ post This time I have created a javascript library for detecting the number of pages from a PDF document. This library is a kind of subset of PDF.js library from …

Continue reading »

Mar
19
2013

Uppercase/Lowercase conversion in Excel through VBA

Well, there is no easy way to ‘change case’ in excel. So i wrote few small VBA snippets to perform case conversion. To perform uppercase conversion on the selected cells Sub UpperCase() Dim Cell As Object For Each Cell In SelectionCell.Value = StrConv(Cell.Value, vbUpperCase) Next End Sub To perform lowercase conversion on the selected cells …

Continue reading »

Oct
24
2012

Building jQuery Tabs from XML

jQuery Tabs and Contents Generated from XML

I have developed a small application to build the jQuery tabs dynamically from XML data source. It’s completely developed using client side technologies – HTML, Javascript and XML. This sample application will display all the posts in my blog grouped into appropriate categories. Each category displayed as a tab.           Watch …

Continue reading »

Older posts «