Hatim.Net

I dread working with VBA but sometimes I have no choice. We had to deliver to a client some data in an excel sheet and embed a macro that would convert the data into a pivot table and then delete the sheet where the data was.

When deleting the sheet Excel opens a confirmation prompt. While clicking it once is no biggie but they had to process 150 files.

The trick is to disable Alerts before the delete and enable them again after.

    Application.DisplayAlerts = False
    Sheets(strSheetName).Delete
    Application.DisplayAlerts = True

If you are trying to find the download link to windows live writer without going through all the marketing spiel here it is link

Literally hours of free WPF training videos from Linda.com. Enjoy!

Through Tim Sneath

Mike Taulty has a number of great LINQ to SQL videos that I recommend checking out here.

While trying to figure out how to implement this feature upon a request from a client I found that it was really simple.

You just need to set the following property to the operations you would like to allow.

myGrid.DisplayLayout.Override.AllowMultiCellOperations

e.g

myGrid.DisplayLayout.Override.AllowMultiCellOperations = AllowMultiCellOperation.All;

I am soooo jealous. Check it out

I had my share of frustration using the ASP.NET Admin tool with it crashing and hanging so maybe having it run straight out of IIS might help. Here is an article that shows you how

There are rumors that Google is in talk to buy the YouTube for about $1.6 Billion.
TechCrunch and the Wall Street Journal both have reported that the rumor is probably solid.

Web-search giant Google is in talks to acquire YouTube for roughly $1.6 billion, a person familiar with the matter says. An acquisition of the closely held company would catapult Google to the lead spot in online video at a moment when consumers are rapidly increasing the amount of time they spend viewing video clips online, and Internet video advertising is booming.

With the recent news Google’s stock (GOOG) saw a significant jump of about +8.69 (2.11%) showing that this is a favorable move for the company.

With the acquisition Google would have an edge over it main competitor, notably Yahoo! Video and MSN Video which don’t have the same share market as Google but both have pretty deep pocket and have been following an acquisition strategy for the last year.

For the first edition of the the microsoft .net framework carnival I would like to link to a few posts from the MSDN Blogs that I found really interesting.

First off all I will start with two error handling tricks from Tolong-lah. His first trick is on error handling invloves using Page and Application Tracing. His Second trick shows how to send SMTP mail and how to use custom errors.

To move on into a different side of the .Net Framework this article shows how to call an unamanged dll from .Net

That would be all for today’s edition. I would love to hear some feedback and how I can improve this Carnival. Also feel free to submit an article that you either wrote or found that you would like to share.