Archive for the ‘.Net’ Category.
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 [...]
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).
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 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 VI