Excel Snippets

Here is code to emove a specific character from the end of a Excel cell. Replace 'A1' with the cell and '-' with the character you want to remove. I found it very useful.

31 October, 2011   

It is a class file which can export to excel. simply call the function and give sql Query and sql connection.

Adding VBA Code Programmatically in Excel

17 July, 2013   

This one creates a back of the current workbook.

22 April, 2013   

Code for adding and positioning multiple charts in a worksheet