excelnoob.blogspot.com
MS Office Experts: February 2012
http://excelnoob.blogspot.com/2012_02_01_archive.html
Monday, February 6, 2012. Loop through all the files in C# 2010. I migrated from VBA to C# a while back. Earlier, with VBA, I used to create Re-Cursive function to loop through all inner folders in a given folder. For example, if I have to search whole files in C: Drive, I will probably need to loop through Drive, then folders and subfolders in VBA. But in C#, you can simply give a parameter to search through the subdirectories as well. DirectoryInfo parent = new DirectoryInfo(@C: Vikas);. In WPF, XAML h...
excelnoob.blogspot.com
MS Office Experts: Find Last Cell, Column And Row in Excel Worksheet
http://excelnoob.blogspot.com/2010/07/find-last-cell-column-and-row-in-excel.html
Friday, July 9, 2010. Find Last Cell, Column And Row in Excel Worksheet. Please find below a small code snippet, which you can use to find the last Used Cell, Row or Column. Public Function LastUsedCell() As Range. Dim rng As Range. Dim activeSht As Worksheet. On Error GoTo ErrHandler. Set activeSht = activeSheet. Set rng = activeSht.Range(A1).SpecialCells(xlCellTypeLastCell). Set LastUsedCell = rng. Set LastUsedCell = Nothing. Public Function LastUsedRow() As Long. Dim rng As Range. Dim rng As Range.
excelnoob.blogspot.com
MS Office Experts: Loop through all the files in C# 2010
http://excelnoob.blogspot.com/2012/02/loop-through-all-files-in-c-2010.html
Monday, February 6, 2012. Loop through all the files in C# 2010. I migrated from VBA to C# a while back. Earlier, with VBA, I used to create Re-Cursive function to loop through all inner folders in a given folder. For example, if I have to search whole files in C: Drive, I will probably need to loop through Drive, then folders and subfolders in VBA. But in C#, you can simply give a parameter to search through the subdirectories as well. DirectoryInfo parent = new DirectoryInfo(@C: Vikas);. Hi All, I am a...
excelnoob.blogspot.com
MS Office Experts: Filter using Predicate (WPF)
http://excelnoob.blogspot.com/2009/03/how-to-filter-listview-items-using.html
Thursday, March 19, 2009. Filter using Predicate (WPF). In WPF, XAML has changed the traditional way of creating and validation the form fields. For example, what if we want to display few of the items in a listview? And what if we want to give user an option to view the items with in the listview? Without WPF, we will create the loop through all the items and will hide/show the items accordingly. But with WPF, we can do it very easily. I will explain in the following example. Add few Items :. We can do ...
excelnoob.blogspot.com
MS Office Experts: August 2010
http://excelnoob.blogspot.com/2010_08_01_archive.html
Tuesday, August 3, 2010. I see a lot of time people ask that they cannot find the last row of the data. One of the most complicated scenario would be, to assign the dynamic source range to a chart. Suppose I have a chart and the number of rows in my chart would keep on changing time to time, so how would I manage this? One option is to use VBA code and assign a new source data whenever it is refreshed. But do we really need code behind to resolve this problem? I would say no :). Parameter 1, Reference.
excelnoob.blogspot.com
MS Office Experts: September 2011
http://excelnoob.blogspot.com/2011_09_01_archive.html
Friday, September 2, 2011. How to Add a Reference in VBA Editor. Although VBA edit does provide loads of libraries inherently, still, we may need to use few libraries which are not included by default. For example, For using Scripting.Dictionary object, or FileSystem object to search the fileSystem in an organized way, we need to add a reference to Microsoft.Scripting.Runtime. If you try to create a FileSystemObject, and write the following code:. Dim dictionary as Scripting.Dictionary. Hi All, I am stil...
excelnoob.blogspot.com
MS Office Experts: ORACLE DAL in C#
http://excelnoob.blogspot.com/2011/12/oracle-dal-in-c.html
Wednesday, December 28, 2011. ORACLE DAL in C#. We can easily find the Data Access Layer for SQL, but here is one which we created for Oracle. Hope it would help you all. Using System.Data;. Using System.Data.SqlClient;. Using System.Configuration;. Using Demo.Common;. Defines common DataService routines for transaction management,. Stored procedure execution, parameter creation, and null value. Private bool isOwner = false; / True if service owns the transaction. Get { return (IDbTransaction) txn; }.
excelnoob.blogspot.com
MS Office Experts: January 2010
http://excelnoob.blogspot.com/2010_01_01_archive.html
Monday, January 18, 2010. Designing a Button in WPF - "Simplest yet cool Button". I have seen a lot of button templates which offer a cool looking styles by overriding the complete button template. Just to give a small style to a button can be complicated as far as overriding the template is concerned. I tried to build a button something like this :. An option could be, to include a new style for my button and override the template. But do we really need to do that? Subscribe to: Posts (Atom). Hi All, I ...
excelnoob.blogspot.com
MS Office Experts: December 2011
http://excelnoob.blogspot.com/2011_12_01_archive.html
Wednesday, December 28, 2011. ORACLE DAL in C#. We can easily find the Data Access Layer for SQL, but here is one which we created for Oracle. Hope it would help you all. Using System.Data;. Using System.Data.SqlClient;. Using System.Configuration;. Using Demo.Common;. Defines common DataService routines for transaction management,. Stored procedure execution, parameter creation, and null value. Private bool isOwner = false; / True if service owns the transaction. Get { return (IDbTransaction) txn; }.