Excel VBA

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

Solved December 22, 2010

Provide a range selection tool/utility to the user in Excel VBA

I am trying to develop a user form in Excel 2007 VBA and want to provide a user with a range selection icon, something…

thumb_up 10 trending_up 8

Solved December 17, 2010

How can I get the key of a dictionary by passing the index value? I'm trying: If rs.Fields("NM").Value = dictNM.key(0) that is, I want…

thumb_up 10 trending_up 3

Solved December 10, 2010

How do I change just the year component of a date using Excel formulas? example: 12/31/07 --> 12/31/11

thumb_up 10 trending_up 3

Solved November 30, 2010

after 10 years of programming I find myself with the daunting task of creating my first Excel application in Excel 2007. I have programmed…

thumb_up 5 trending_up 9

Solved November 17, 2010

Would it be wrong if write the following code Sub Something() Dim i As integer Dim xRange As Range Dim yRange As Range Set…

thumb_up 12 trending_up 2

Solved November 10, 2010

In Excel (2003), I want to limit the selection of values in a cell to allowable values from another spreadsheet. For example, in the…

thumb_up 13 trending_up 9

Solved November 9, 2010

I have written a procedure that will open a xls from a local disc, refresh the data in it and then save it again.…

thumb_up 7 trending_up 6

Solved November 5, 2010

I generate an excel spread-cheat with c# and I want to freeze the first column. This is the code that I use : public…

thumb_up 9 trending_up 3

Solved October 8, 2010

Also, would it be illadvised to use RExcel for corporate work? Also, what are some advantages / disadvantages of using it? How small do…

thumb_up 16 trending_up 8

Solved October 1, 2010

I want to know what the fastest way is of reading and writing data to and from an open Excel workbook to c# objects.…

thumb_up 34 trending_up 26