Excel VBA

<p>Data processing, dynamic reporting, and workbook automation.</p>

Solved March 30, 2012

Excel VBA Substring

I am writing a macro that takes a list of names that are in an LDAP format converts them to First, Last (region). For…

thumb_up 10 trending_up 7

Solved March 21, 2012

I have an excel sheet which has some huge data. Data is organized as follows, A set of 7 columns and n rows; as…

thumb_up 6 trending_up 4

Solved March 20, 2012

I have 2 checkboxes, what i want to do is when i select one, the other 1 will be deselected, which means user will…

thumb_up 8 trending_up 3

Solved March 12, 2012

I have to count number of distinct values from a column and print it with the distinct value and count in another sheet. I…

thumb_up 7 trending_up 4

Solved March 9, 2012

A lot of the solutions here on SO involve using CountIf to find duplicates. When I have a list of 100,000+ values however, it…

thumb_up 9 trending_up 5

Solved March 8, 2012

First of all, hello to everybody! I have a piece of code which is creating an Excel file by using an open source library…

thumb_up 3 trending_up 7

Solved March 6, 2012

I have a Do .. While loop in which two For.. loops are nested; the first For.. loop counts up from 1 to X,…

thumb_up 10 trending_up 6

Solved March 5, 2012

I know that excel is capable of opening html files directly. But the content of the file will still be html. Is there any…

thumb_up 11 trending_up 11

Solved February 16, 2012

There is a column like the above,now, i want to add some records as the following: 20120210 20120211 20120212 20120213 ...... Is there a…

thumb_up 14 trending_up 10

Solved January 31, 2012

I have a script that does various things and the end result is one large table. I was wondering how I could export this…

thumb_up 44 trending_up 27