Find attached a video comprising of bulk signature scanning for accounts where SS not available through vb macros.
Macro code is as follows:
Private Sub Worksheet_Activate()
Dim ssource, ddest, SS As String
For I = 1 To 2000
ssource = "D:\ZR.BMP"
SS = Trim(Worksheets("SS").Cells(I, 1).Value)
ddest = "D:\SS\" & "ZR" & SS & ".bmp"
FileCopy ssource, ddest
Next I
End Sub
Video Tutorial for Auto SS Scanner
Shared by G Gurusivam, System Administrator, 09500665218 thanks to Rajesh CR
Updates:
Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates
Post a Comment