Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
>>main Option Explicit Private Sub Timer1_Timer() UpLbl.Caption = FormatCount(GetTickCount, DaysHoursMinutesSecondsMilliseconds) End Sub >>module Public Enum TimeFormatType DaysHoursMinutesSecondsMilliseconds = 0 DaysHoursMinutesSeconds = 1 DHMSMColonSeparated = 2 DaysHoursMinutes = 3 End Enum Public Function FormatCount(Count As Long, Optional FormatType As TimeFormatType = 0) As String Dim Days As Long, Hours As Long, Minutes As Long, Seconds As Long Count = Count \ 1000 Days = Count \ (24& * 3600&) If Days > 0 Then Count = Count - (24& * 3600& * Days) Hours = Count \ 3600& If Hours > 0 Then Count = Count - (3600& * Hours) Minutes = Count \ 60 Seconds = Count Mod 60 Select Case FormatType Case 0 FormatCount = Days & " days, " & Hours & " hours, " & Minutes & " minutes, " & Seconds & " seconds" Case 1 FormatCount = Days & ":" & Hours & ":" & Minutes & ":" & Seconds Case 2 FormatCount = Days & " days, " & Hours & " hours, " & Minutes & " minutes" End Select End Function
|Change the path of the data source in my Excel pivot table with macro||4||43|
|to transfer string from C lanaguage to VBA||4||65|
|HOW D I CLEAR PICTURES IN IMAGE CONTROL AND COMMENTS IN CELLS WHEN WORKBOOK IS OPENED||18||97|
|Automatically generate a pdf file from an excel file and email out everyday||2||39|