Bulk signature scanning for accounts where ss not available

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

Previous Post Next Post

Most Visited

Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates

Search Content of www.potools.blogspot.com @