26 November 2017

Excel VBA Switch Random File Name

Ni aku kongsikan VBA untuk switch file yang random ending file name


Sub CopyAllJobs()
    Dim myWindow As Window
    For Each myWindow In Windows
        If Left(myWindow.Caption, 8) = "All Jobs" Then myWindow.Activate '''': Exit Sub
    Next myWindow
   
End Sub

No comments: