' ================== ' ResetStartEndTimes ' ================== ' Version 1.0.0.1 - February 19th 2014 ' Copyright © Steve MacGuire 2011-2014 ' http://samsoft.org.uk/iTunes/ResetStartEndTimes.vbs ' Please visit http://samsoft.org.uk/iTunes/scripts.asp for updates ' ======= ' Licence ' ======= ' This program is free software: you can redistribute it and/or modify it under the terms ' of the GNU General Public License as published by the Free Software Foundation, either ' version 3 of the License, or (at your option) any later version. ' This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; ' without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. ' See the GNU General Public License for more details. ' Please visit http://www.gnu.org/licenses/gpl-3.0-standalone.html to view the GNU GPLv3 licence. ' =========== ' Description ' =========== ' Resets start time if greater than zero and end time if less than song length ' Written partly in response to this thread in Apple Support Communities ' https://discussions.apple.com/message/24918202#24918202 ' ========= ' ChangeLog ' ========= ' Version 1.0.0.1 - Initial version ' ========== ' To-do List ' ========== ' Add things to do ' ============================= ' Declare constants & variables ' ============================= Option Explicit ' Declare all variables before use Const Kimo=False ' True if script expects "Keep iTunes Media folder organised" to be disabled Const Min=0 ' Minimum number of tracks this script should work with Const Max=0 ' Maximum number of tracks this script should work with, 0 for no limit Const Warn=500 ' Warning level, require confirmation for procssing above this level Dim Intro,Outro,Check ' Manage confirmation dialogs Dim PB,Prog,Debug ' Control the progress bar Dim Clock,T1,T2,Timing ' The secret of great comedy Dim Named,Source ' Control use on named playlist Dim Playlist,List ' Name for any generated playlist, and the object itself Dim iTunes ' Handle to iTunes application Dim Tracks ' A collection of track objects Dim Count ' The number of tracks Dim D,M,P,S,U,V ' Counters Dim nl,tab ' New line/tab strings Dim IDs ' A dictionary object used to ensure each object is processed once Dim Quit ' Used to abort script Const Title="Reset Start & End Times" Const Summary="Resets start time if greater than zero and end time if less than song length." Dim DCs,TCs ' More global dictionary objects ' ======================= ' Initialise user options ' ======================= Intro=True ' Set false to skip initial prompts, avoid if non-reversible actions Outro=True ' Produce summary report Check=True ' Track-by-track confirmation Prog=True ' Display progress bar Debug=True ' Include any debug messages in progress bar Timing=True ' Display running time in summary report Named=False ' Force script to process specific playlist rather than current selection or playlist Source="" ' Named playlist to process, use "Library" for entire library ' ============ ' Main program ' ============ GetTracks ' Set things up ProcessTracks ' Main process Report ' Summary ' =================== ' End of main program ' =================== ' =============================== ' Declare subroutines & functions ' =============================== ' Note: The bulk of the code in this script is concerned with making sure that only suitable tracks are processed by ' the following module and supporting numerous options for track selection, confirmation, progress and results. ' Change text in Album, AlbumArtist, Artist and Name fields into Title Case ' Modified 2014-02-19 Sub Action(T) Dim A,B,C,Key With T StartEvent 'Ignore tracks with unknown artist/album or no track number If .Start>0 Then .Start=0 If .Finish0 Then FormatMMSS=H & ":" & M & ":" & S Else FormatMMSS=M & ":" & S If Left(FormatMMSS,1)="0" Then FormatMMSS=Mid(FormatMMSS,2) End If End Function ' Custom info message for progress bar ' Modified 2013-12-21 Function Info(T) Dim A,B With T ' NB Adding an empty string prevents assignment errors where value is null A=.AlbumArtist & "" : If A="" Then A=.Artist & "" : If A="" Then A="Unknown Artist" B=.Album & "" : If B="" Then B="Unknown Album" Info="Updating: " & A & " - " & B & " - " & .Name End With End Function ' Custom prompt for track-by-track confirmation ' Modified 2014-02-19 Function Prompt(T) Dim A,AA,AL,AR,B,C,DC,DN,Key,NA,NTF,NTS,TF,TS With T A=.AlbumArtist & "" : If A="" And .Compilation Then A="Various Artists" Else If A="" Then A=.Artist & "" B=.Album & "" C=.DiscNumber : If C=0 Then C=1 Key=LCase(A & "\" & B) AL=.Album & "" AA=.AlbumArtist & "" AR=.Artist & "" NA=.Name & "" TS=.Start TF=.Finish NTS=0 NTF=TimeToSecs(.Time) Prompt="Update starred properties?" Prompt=Prompt & nl & nl & "Album" & tab & tab & AL ': If NAL<>.Album Then Prompt=Prompt & " *" & nl & "->" & tab & tab & NAL Prompt=Prompt & nl & nl & "Album Artist" & tab & AA ': If NAA<>.AlbumArtist Then Prompt=Prompt & " *" & nl & "->" & tab & tab & NAA Prompt=Prompt & nl & nl & "Artist" & tab & tab & AR ': If NAR<>.Artist Then Prompt=Prompt & " *" & nl & "->" & tab & tab & NAR Prompt=Prompt & nl & nl & "Name" & tab & tab & NA ': If NNA<>.Name Then Prompt=Prompt & " *" & nl & "->" & tab & tab & NNA Prompt=Prompt & nl & nl & "Start" & tab & tab & FormatMMSS(TS) : If TS<>NTS Then Prompt=Prompt & " *" & nl & "->" & tab & tab & FormatMMSS(NTS) Prompt=Prompt & nl & nl & "End" & tab & tab & FormatMMSS(TF) : If TF<>NTF Then Prompt=Prompt & " *" & nl & "->" & tab & tab & FormatMMSS(NTF) End With End Function ' Custom status message for progress bar ' Modified 2011-10-21 Function Status(N) Status="Processing " & N & " of " & Count End Function ' Custom status message for progress bar ' Modified 2014-02-19 Function TimeToSecs(T) Dim P P=Instr(T,":") TimeToSecs=Left(T,P-1)*60+Mid(T,P+1) End Function ' Test for tracks which can be usefully updated ' Modified 2014-02-19 Function Updateable(T) Dim A,B,C,ID,Key ID=PersistentID(T) Updateable=False ' Default position If IDs.Exists(ID) Then ' Ignore tracks already processed D=D+1 ' Increment duplicate tracks Else IDs.Add ID,0 ' Note ID to prevent reprocessing this track If T.Location="" Then ' Missing files can't be processed by this script M=M+1 ' Increment missing tracks If Prog Then PB.SetDebug "
Missing file!" : WScript.Sleep 500 Else With T Updateable=(.Start>0 Or .Finish0 Then FormatTime=H & Plural(H," hours "," hour ") & M & Plural(M," mins"," min") 'FormatTime=H & ":" & M & ":" & S Else FormatTime=M & Plural(M," mins "," min ") & S & Plural(S," secs"," sec") 'FormatTime=M & " :" & S 'If Left(FormatTime,1)="0" Then FormatTime=Mid(FormatTime,2) End If End If End Function ' Initialise track selections, quit script if track selection is out of bounds or user aborts ' Modified 2011-11-13 Sub GetTracks Dim Q,R ' Initialise global variables nl=vbCrLf : tab=Chr(9) : Quit=False D=0 : M=0 : P=0 : S=0 : U=0 : V=0 ' Initialise global objects Set IDs=CreateObject("Scripting.Dictionary") Set iTunes=CreateObject("iTunes.Application") Set Tracks=iTunes.SelectedTracks ' Get current selection If iTunes.BrowserWindow.SelectedPlaylist.Source.Kind<>1 And Source="" Then Source="Library" : Named=True ' Ensure section is from the library source 'If iTunes.BrowserWindow.SelectedPlaylist.Name="Ringtones" And Source="" Then Source="Library" : Named=True ' and not ringtones (which cannot be processed as tracks???) If iTunes.BrowserWindow.SelectedPlaylist.Name="Radio" And Source="" Then Source="Library" : Named=True ' or radio stations (which cannot be processed as tracks) If iTunes.BrowserWindow.SelectedPlaylist.Name=Playlist And Source="" Then Source="Library" : Named=True ' or a playlist that will be regenerated by this script If Named Or Tracks Is Nothing Then ' or use a named playlist If Source<>"" Then Named=True If Source="Library" Then ' Get library playlist... Set Tracks=iTunes.LibraryPlaylist.Tracks Else ' or named playlist On Error Resume Next ' Attempt to fall back to current selection for non-existent source Set Tracks=iTunes.LibrarySource.Playlists.ItemByName(Source).Tracks On Error Goto 0 If Tracks is Nothing Then ' Fall back Named=False Source=iTunes.BrowserWindow.SelectedPlaylist.Name Set Tracks=iTunes.SelectedTracks If Tracks is Nothing Then Set Tracks=iTunes.BrowserWindow.SelectedPlaylist.Tracks End If End If End If End If If Named And Tracks.Count=0 Then ' Quit if no tracks in named source If Intro Then MsgBox "The playlist " & Source & " is empty, there is nothing to do.",vbExclamation,Title WScript.Quit End If If Tracks.Count=0 Then Set Tracks=iTunes.LibraryPlaylist.Tracks If Tracks.Count=0 Then ' Can't select ringtones as tracks? MsgBox "This script cannot process " & iTunes.BrowserWindow.SelectedPlaylist.Name & ".",vbExclamation,Title WScript.Quit End If ' Check there is a suitable number of suitable tracks to work with Count=Tracks.Count If CountMax And Max>0) Then If Max=0 Then MsgBox "Please select " & Min & " or more tracks in iTunes before calling this script!",0,Title WScript.Quit Else MsgBox "Please select between " & Min & " and " & Max & " tracks in iTunes before calling this script!",0,Title WScript.Quit End If End If ' Check if the user wants to proceed and how Q=Summary If Q<>"" Then Q=Q & nl & nl If Warn>0 And Count>Warn Then Intro=True Q=Q & "WARNING!" & nl & "Are you sure you want to process " & Count & " tracks" If Named Then Q=Q & nl Else Q=Q & "Process " & Count & " track" & Plural(Count,"s "," ") End If If Named Then Q=Q & "from the " & Source & " playlist" Q=Q & "?" If Intro Or (Prog And UAC) Then If Check Then Q=Q & nl & nl Q=Q & "Yes" & tab & ": Process track" & Plural(Count,"s","") & " automatically" & nl Q=Q & "No" & tab & ": Preview & confirm each action" & nl Q=Q & "Cancel" & tab & ": Abort script" End If If Kimo Then Q=Q & nl & nl & "NB: Disable ''Keep iTunes Media folder organised'' preference before use." If Prog And UAC Then Q=Q & nl & nl & "NB: Disable User Access Control to allow progess bar to operate" & nl Q=Q & "or change the declaration ''Prog=True'' to ''Prog=False''." Prog=False End If If Check Then R=MsgBox(Q,vbYesNoCancel+vbQuestion,Title) Else R=MsgBox(Q,vbOKCancel+vbQuestion,Title) End If If R=vbCancel Then WScript.Quit If R=vbYes or R=vbOK Then Check=False Else Check=True End If End If If Check Then Prog=False ' Suppress progress bar if prompting for user input End Sub ' Return the persistent object representing the track from its ID as a string ' Modified 2012-09-05 Function ObjectFromID(ID) Set ObjectFromID=iTunes.LibraryPlaylist.Tracks.ItemByPersistentID(Eval("&H" & Left(ID,8)),Eval("&H" & Right(ID,8))) End Function ' Create a string representing the 64 bit persistent ID of an iTunes object ' Modified 2012-08-24 Function PersistentID(T) PersistentID=Right("0000000" & Hex(iTunes.ITObjectPersistentIDHigh(T)),8) & "-" & Right("0000000" & Hex(iTunes.ITObjectPersistentIDLow(T)),8) End Function ' Return the persistent object representing the track ' Keeps hold of an object that might vanish from a smart playlist as it is updated ' Modified 2012-09-11 Function PersistentObject(T) Dim Ext Ext=LCase(Mid(T.Location,InStrRev(T.Location,"."))) If Instr(".ipa.ipg.m4r",Ext) Then Set PersistentObject=T Else Set PersistentObject=iTunes.LibraryPlaylist.Tracks.ItemByPersistentID(iTunes.ITObjectPersistentIDHigh(T),iTunes.ITObjectPersistentIDLow(T)) End If End Function ' Return relevant string depending on whether value is plural or singular ' Modified 2011-10-04 Function Plural(V,P,S) If V=1 Then Plural=S Else Plural=P End Function ' Format a list of values for output ' Modified 2012-08-25 Function PrettyList(L,N) If L="" Then PrettyList=N & "." Else PrettyList=Replace(Left(L,Len(L)-1)," and" & nl,"," & nl) & " and" & nl & N & "." End If End Function ' Loop through track selection processing suitable items ' Modified 2012-08-25 Sub ProcessTracks Dim C,I,N,Q,R,T N=0 If Prog Then ' Create ProgessBar Set PB=New ProgBar PB.SetTitle Title PB.Show End If Clock=0 : StartTimer For I=Count To 1 Step -1 ' Work backwards in case edit removes item from selection N=N+1 If Prog Then PB.SetStatus Status(N) PB.Progress N-1,Count End If Set T=PersistentObject(Tracks(I)) ' Attach to object in library playlist If Prog Then PB.SetInfo Info(T) If T.Kind=1 Then ' Ignore tracks which can't change If Updateable(T) Then ' Ignore tracks which won't change If Check Then ' Track by track confirmation Q=Prompt(T) StopTimer ' Don't time user inputs R=MsgBox(Q,vbYesNoCancel+vbQuestion,Title) StartTimer Select Case R Case vbYes C=True Case vbNo C=False S=S+1 ' Increment skipped tracks Case Else Quit=True Exit For End Select Else C=True End If If C Then ' We have a valid track, now do something with it Action T End If End If End If P=P+1 ' Increment processed tracks If Quit Then Exit For ' Abort loop on user request Next StopTimer If Prog And Not Quit Then PB.Progress Count,Count WScript.Sleep 250 PB.Close End If End Sub ' Output report ' Modified 2012-08-25 Sub Report If Not Outro Then Exit Sub Dim L,T L="" If Quit Then T="Script aborted!" & nl & nl Else T="" T=T & P & " track" & Plural(P,"s","") If P0 Then L=PrettyList(L,D & Plural(D," were duplicates"," was a duplicate") & " in the list") If V>0 Then L=PrettyList(L,V & " did not need updating") If U>0 Or V=0 Then L=PrettyList(L,U & Plural(U," were"," was") & " updated") If S>0 Then L=PrettyList(L,S & Plural(S," were"," was") & " skipped") If M>0 Then L=PrettyList(L,M & Plural(M," were"," was") & " missing") T=T & L If Timing Then T=T & nl & nl If Check Then T=T & "Processing" Else T=T & "Running" T=T & " time: " & FormatTime(Clock) End If MsgBox T,vbInformation,Title End Sub ' Start timing event ' Modified 2011-10-08 Sub StartEvent T2=Timer End Sub ' Start timing session ' Modified 2011-10-08 Sub StartTimer T1=Timer End Sub ' Stop timing event and display elapsed time in debug section of Progress Bar ' Modified 2011-11-07 Sub StopEvent If Prog Then T2=Timer-T2 If T2<0 Then T2=T2+86400 ' Watch for timer running over midnight If Debug Then PB.SetDebug "
Last iTunes call took " & FormatTime(T2) End If End Sub ' Stop timing session and add elapased time to running clock ' Modified 2011-10-08 Sub StopTimer Clock=Clock+Timer-T1 If Clock<0 Then Clock=Clock+86400 ' Watch for timer running over midnight End Sub ' Detect if User Access Control is enabled, UAC prevents use of progress bar ' Modified 2011-10-18 Function UAC Const HKEY_LOCAL_MACHINE=&H80000002 Const KeyPath="Software\Microsoft\Windows\CurrentVersion\Policies\System" Const KeyName="EnableLUA" Dim Reg,Value Set Reg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\default:StdRegProv") ' Use . for local computer, otherwise could be computer name or IP address Reg.GetDWORDValue HKEY_LOCAL_MACHINE,KeyPath,KeyName,Value ' Get current property If IsNull(Value) Then UAC=False Else UAC=(Value<>0) End Function ' ================== ' Progress Bar Class ' ================== ' Progress/activity bar for vbScript implemented via IE automation ' Can optionally rebuild itself if closed or abort the calling script ' Modified 2011-10-16 Class ProgBar Public Cells,Height,Width,Respawn,Title,Version Private Active,Blank,Dbg,Filled(),FSO,IE,Info,NextOn,NextOff,Status,SHeight,SWidth,Temp ' User has closed progress bar, abort or respwan? ' Modified 2011-10-09 Public Sub Cancel() If Respawn And Active Then Active=False If Respawn=1 Then Show ' Ignore user's attempt to close and respawn Else Dim R StopTimer ' Don't time user inputs R=MsgBox("Abort Script?",vbExclamation+vbYesNoCancel,Title) StartTimer If R=vbYes Then On Error Resume Next CleanUp Respawn=False Quit=True ' Global flag allows main program to complete current task before exiting Else Show ' Recreate box if closed End If End If End If End Sub ' Delete temporary html file ' Modified 2011-10-04 Private Sub CleanUp() FSO.DeleteFile Temp ' Delete temporary file End Sub ' Close progress bar and tidy up ' Modified 2011-10-04 Public Sub Close() On Error Resume Next ' Ignore errors caused by closed object If Active Then Active=False ' Ignores second call as IE object is destroyed IE.Quit ' Remove the progess bar CleanUp End If End Sub ' Initialize object properties ' Modified 2012-09-05 Private Sub Class_Initialize() Dim I,Items,strComputer,WMI ' Get width & height of screen for centering ProgressBar strComputer="." Set WMI=GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set Items=WMI.ExecQuery("Select * from Win32_OperatingSystem",,48) 'Get the OS version number (first two) For Each I in Items Version=Left(I.Version,3) Next Set Items=WMI.ExecQuery ("Select * From Win32_DisplayConfiguration") For Each I in Items SHeight=I.PelsHeight SWidth=I.PelsWidth Next If Debug Then Height=160 ' Height of containing div Else Height=120 ' Reduce height if no debug area End If Width=300 ' Width of containing div Respawn=True ' ProgressBar will attempt to resurect if closed Blank=String(50,160) ' Blanks out "Internet Explorer" from title Cells=25 ' No. of units in ProgressBar, resize window if using more cells ReDim Filled(Cells) ' Array holds current state of each cell For I=0 To Cells-1 Filled(I)=False Next NextOn=0 ' Next cell to be filled if busy cycling NextOff=Cells-5 ' Next cell to be cleared if busy cycling Dbg=" " ' Initital value for debug text Info=" " ' Initital value for info text Status=" " ' Initital value for status text Title="Progress Bar" ' Initital value for title text Set FSO=CreateObject("Scripting.FileSystemObject") ' File System Object Temp=FSO.GetSpecialFolder(2) & "\ProgBar.htm" ' Path to Temp file End Sub ' Tidy up if progress bar object is destroyed ' Modified 2011-10-04 Private Sub Class_Terminate() Close End Sub ' Display the bar filled in proportion X of Y ' Modified 2011-10-18 Public Sub Progress(X,Y) Dim F,I,L,S,Z If X<0 Or X>Y Or Y<=0 Then MsgBox "Invalid call to ProgessBar.Progress, variables out of range!",vbExclamation,Title Exit Sub End If Z=Int(X/Y*(Cells)) If Z=NextOn Then Exit Sub If Z=NextOn+1 Then Step False Else If Z>NextOn Then F=0 : L=Cells-1 : S=1 Else F=Cells-1 : L=0 : S=-1 End If For I=F To L Step S If I>=Z Then SetCell I,False Else SetCell I,True End If Next NextOn=Z End If End Sub ' Clear progress bar ready for reuse ' Modified 2011-10-16 Public Sub Reset Dim C For C=Cells-1 To 0 Step -1 IE.Document.All.Item("P",C).classname="empty" Filled(C)=False Next NextOn=0 NextOff=Cells-5 End Sub ' Directly set or clear a cell ' Modified 2011-10-16 Public Sub SetCell(C,F) On Error Resume Next ' Ignore errors caused by closed object If F And Not Filled(C) Then Filled(C)=True IE.Document.All.Item("P",C).classname="filled" ElseIf Not F And Filled(C) Then Filled(C)=False IE.Document.All.Item("P",C).classname="empty" End If End Sub ' Set text in the Dbg area ' Modified 2011-10-04 Public Sub SetDebug(T) On Error Resume Next ' Ignore errors caused by closed object Dbg=T IE.Document.GetElementById("Debug").InnerHTML=T End Sub ' Set text in the info area ' Modified 2011-10-04 Public Sub SetInfo(T) On Error Resume Next ' Ignore errors caused by closed object Info=T IE.Document.GetElementById("Info").InnerHTML=T End Sub ' Set text in the status area ' Modified 2011-10-04 Public Sub SetStatus(T) On Error Resume Next ' Ignore errors caused by closed object Status=T IE.Document.GetElementById("Status").InnerHTML=T End Sub ' Set title text ' Modified 2011-10-04 Public Sub SetTitle(T) On Error Resume Next ' Ignore errors caused by closed object Title=T IE.Document.Title=T & Blank End Sub ' Create and display the progress bar ' Modified 2011-10-17 Public Sub Show() Const HKEY_CURRENT_USER=&H80000001 Const KeyPath="Software\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_LOCALMACHINE_LOCKDOWN" Const KeyName="iexplore.exe" Dim File,I,Reg,State,Value Set Reg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\default:StdRegProv") ' Use . for local computer, otherwise could be computer name or IP address 'On Error Resume Next ' Ignore possible errors ' Make sure IE is set to allow local content, at least while we get the Progress Bar displayed Reg.GetDWORDValue HKEY_CURRENT_USER,KeyPath,KeyName,Value ' Get current property State=Value ' Preserve current option Value=0 ' Set new option Reg.SetDWORDValue HKEY_CURRENT_USER,KeyPath,KeyName,Value ' Update property 'If Version<>"5.1" Then Prog=False : Exit Sub ' Need to test for Vista/Windows 7 with UAC Set IE=WScript.CreateObject("InternetExplorer.Application","Event_") Set File=FSO.CreateTextFile(Temp, True) With File .WriteLine "" .WriteLine "" .WriteLine "" & Title & Blank & "" .WriteLine "" .WriteLine "" .WriteLine "" .WriteLine "
" .WriteLine "" .WriteLine "
" & Status & "
" .WriteLine "" ' Write out cells For I=0 To Cells-1 If Filled(I) Then .WriteLine "" Else .WriteLine "" End If Next .WriteLine "
  
" .WriteLine "
" .WriteLine "" & Info & "
" .WriteLine "" & Dbg & "
" .WriteLine "
" End With ' Create IE automation object with generated HTML With IE .width=Width+30 ' Increase if using more cells .height=Height+55 ' Increase to allow more info/debug text If Version>"5.1" Then ' Allow for bigger border in Vista/Widows 7 .width=.width+10 .height=.height+10 End If .left=(SWidth-.width)/2 .top=(SHeight-.height)/2 .navigate "file://" & Temp '.navigate "http://samsoft.org.uk/progbar.htm" .addressbar=False .menubar=False .resizable=False .toolbar=False On Error Resume Next .statusbar=False ' Causes error on Windows 7 or IE 9 On Error Goto 0 .visible=True ' Causes error if UAC is active End With Active=True ' Restore the user's property settings for the registry key Value=State ' Restore option Reg.SetDWORDValue HKEY_CURRENT_USER,KeyPath,KeyName,Value ' Update property Exit Sub End Sub ' Increment progress bar, optionally clearing a previous cell if working as an activity bar ' Modified 2011-10-05 Public Sub Step(Clear) SetCell NextOn,True : NextOn=(NextOn+1) Mod Cells If Clear Then SetCell NextOff,False : NextOff=(NextOff+1) Mod Cells End Sub ' Self-timed shutdown ' Modified 2011-10-05 Public Sub TimeOut(S) Dim I Respawn=False ' Allow uninteruppted exit during countdown For I=S To 2 Step -1 SetDebug "
Closing in " & I & " seconds" & String(I,".") WScript.sleep 1000 Next SetDebug "
Closing in 1 second." WScript.sleep 1000 Close End Sub End Class ' Fires if progress bar window is closed, can't seem to wrap up the handler in the class ' Modified 2011-10-04 Sub Event_OnQuit() PB.Cancel End Sub ' ============== ' End of listing ' ==============