The “VerifyClickOnceSigningSettings” task failed unexpectedly.

This error occurs when you are trying to develop office applications.

Error        The “VerifyClickOnceSigningSettings” task failed unexpectedly.
System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.VisualStudio.Tools.Applications.Hosting, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. Das System kann die angegebene Datei nicht finden.

This error means that he can’t find an assembly which is contained in VSTA-SDK. The SDK can be download from microsoft website.

[] How to return calendar week from a date

This is a method how to calculate the calendar week from a date:

Imports System.Globalization
Public Function getCalendarWeek(ByVal Datum As Date) As Short
Dim CUI As New CultureInfo (CultureInfo.CurrentCulture.Name)
Return CUI.Calendar.GetWeekOfYear(Datum,_
End Function

by Jens Hantschel