Sub link() Dim k As Integer Dim rand As Integer Dim URL As String Dim foldernum As Integer Dim folderstring As String Dim filenum As Integer Dim filestring As String k = 1 'for AC Numbers For i = 11 To 40 foldernum = 0 foldernum = 1000 + i folderstring = CStr(foldernum) folderstring = Mid(folderstring, 2, 3) folder = "ac" & folderstring 'folderstring = Sheets(2).Cells(i, 1) ' for Number of Random files For j = 1 To 10 rand = Int(Rnd * (200 - 1) + 1) filenum = 0 filenum = 1000 + rand filestring = CStr(filenum) filestring = Mid(filestring, 2, 3) 'URL = "http://ceobihar.nic.in/PSCDROM/ac" & folderstring & "/i" & folderstring & "0" & filestring & ".pdf" URL = "http://www.elections.tn.gov.in/pdfs/dt1/" & folder & "/" & folder & filestring & ".pdf" ' URL =http://www.wb.nic.in/wbeco/EROLLS/PDF/English/A001/a0010105 .pdf Cells(k, 1) = folderstring Cells(k, 2) = folder Cells(k, 3) = filestring Cells(k, 3) = URL k = k + 1 Next j Next i End Sub plz define it
How to close a file in perl?
Explain the purpose of o-ring, wearings in the centrifugal pumps?
Explain search factor (sf) & replication factor (rf)?
How can we calculate the motor frame sizes?
what is the entry of credit card received excess amount entry in tally and their under group names
What is the function of the correction system? : abap data dictionary
Explain the component of storage in windows azure platform?
What is the depth-first search algorithm?
Which service is used for making ajax calls in angular?
What is the dictionary?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
How you will rate urself in QTP in the range of 0 to 5
Are the reserved instances can available for multi-az deployments?
How can i get GR form (GR No.) for Exports ? please give me a link of website with steps ?