Archive for the ‘.Net’ Category.

Using LINQ to find and open in Excel 2007 the newest file in a folder

This is one of two approaches inspired by Dick Kusleika’s post on opening in Excel the newest CSV file in a given folder (http://www.dailydoseofexcel.com/archives/2009/05/01/opening-the-newest-file-in-a-folder-with-vba/).
I explain the development of the Excel 2007 add-in at http://www.tushar-mehta.com/publish_train/xl_vba_cases/LINQ_newest_file.htm. The key issues addressed are the use of LINQ to query the file directory to find the newest file and [...]

C# Macro Recorder

Well, not quite. via Unhandled Perception, it’s the Code Converter.
Convert VB to C# or C# to VB
From
Sub ConvertCode()
   
    Dim i As Long
    Dim x As Double
   
    For i = 1 To 100
        x = x + (i ^ 2)
    Next i
    [...]

Customize Ribbon UI for Excel 2007 with ‘Managed’ COM Add-ins (VB.NET 2005)

Customize Ribbon UI for Excel 2007 with ‘Managed’ COM Add-ins (VB.NET 2005).

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part X

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part X.

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part IX

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part IX.

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VIII

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VIII.

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VII

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VII

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VI

Creating and deploying Managed COM add-ins with VB.NET 2005 - Part VI