Mathias Brandewinder on .NET, F#, VSTO and Excel development, and quantitative analysis / machine learning.
by Mathias 13. July 2013 10:43

It looks like this summer will be my strangest vacation in a while – I’ll be taking a F# road trip of sorts in August, talking about F# at user groups all over the United States. How this crazy plan took shape exactly I am not quite sure in retrospect, but I am really looking forward to meeting all the local communities – this will be fun!

As of July 13th July 28th, here is the plan:

July 31, Sacramento: “Coding Dojo: a gentle introduction to Machine Learning with F#”

August 8, Houston: “An Introduction to F# for the C# Developer”

August 9, Houston: “Coding Dojo: a gentle introduction to Machine Learning with F#”

August 12, Nashville: “Coding Dojo: a gentle introduction to Machine Learning with F#”

August 13, Charlotte: “Coding Dojo: a gentle introduction to Machine Learning with F#”

August 14, Raleigh: “An Introduction to F# for the C# Developer”

August 15, Raleigh: “Coding Dojo: a gentle introduction to Machine Learning with F#”

August 16, Washington DC: “Coding Dojo: a gentle introduction to Machine Learning with F#”

August 17, Philadelphia: “Coding Dojo: a gentle introduction to Machine Learning with F#”

August 19, New York City: “Coding Dojo: a gentle introduction to Machine Learning with F#”

August 20, Boston: “An introduction to F# for the C# developer”

August 21, Boston: “Coding Dojo: a gentle introduction to Machine Learning“

August 22, Detroit: TBA

… and a few more should be added to the list soon! I’ll let you extrapolate what possible cities could be following, given the map below. Stay tuned for updates.


View Larger Map

Huge thanks to the people who helped make this happen – I am sure I forgot some of you, sorry about that, and I’ll owe you a beer when I visit your city!

@zychr and the Sacramento .NET group

@panesofglass and the Houston F# group

@bryan_hunter and @NashFP in Nashville

@mattduffield and the Charlotte Alt.NET group

@Jamie_Dixon and the Triangle .NET group 

@devshorts and the newly founded Washington DC F# meetup group!

@briandonahue and the Philly Alt.NET group

@rickasaurus and the NYC F# group

@plepilov, @talbott, @jonnyboats and @hackreduce + New England F# group in Boston

… and of course @INETA!

by Mathias 11. March 2010 12:15

While working on my VSTO Excel add-in tutorial, I came across the following issue: I need to know whether a worksheet has been deleted. The reason I care is that when it happens, I need to update the display of the worksheets that are currently open, and remove it from there.

I was very surprised to find out that there seems to be no event for this. The Application object, which represents the Excel application, has a WorkbookBeforeClose event; the Workbook object has an event BeforeClose, triggered when the Workbook is being closed. So naturally, I expected to find something equivalent for the Worksheet object, at either the Application, Workbook, Sheets, Worksheets, or Worksheet level – no such luck.

I looked around on the web, and from what I can tell, there is no native event for this, and I came across multiple posts advocating to handle this through Worksheet.Activate and/or Worksheet.Deactivate. I see how this catches the obvious use case, namely, the user selects the sheet and deletes it – which causes the sheet to be activated, and then another worksheet to be activated once the deletion is performed. Unfortunately, this doesn’t catch all the cases: as far as I can tell, it is perfectly possible to delete a worksheet without ever changing which sheet is active. To prove the point, create a workbook, and add the following macro:

Public Sub DeleteSheet3()
    Application.DisplayAlerts = False
    Sheets("Sheet3").Delete
    Application.DisplayAlerts = True
End Sub

More...

by Mathias 11. August 2008 19:12

Just plugging the next Bay.Net Education Day (which I am organizing), where Mark Michaelis will

start with a blank slate, the Visual Studio Wizard, and proceed to create a series of assemblies that comprise .NET 3.0/.NET 3.5 sample application.  The result will be a whirl wind introduction to technologies such as Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), Ajax, SharePoint, Visual Studio Unit Testing, LINQ and much more.  Attend this all day session to catch up with where Microsoft .NET technology is today and gain insight into where it is going tomorrow.

Should be a great event - it will take place Saturday September 6, at Foothill College; you can register here.

Comments

Comment RSS