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

2782

Which is better magento or opencart?

1

Do you know what is the use of zend framework?

179

What is persistence mode in cache?

2289

What is the difference between length and size in java?

1033

Explain bean in spring and list the different scopes of spring bean?

454

What all documents get created during gr entry in wm process.

685

What is your aim in life? What are you doing to achieve it?

1323

What do you know about PM Suraksha Bima Yojana?

1182

What is forced commutation?

1141

What is scenario in excel?

715

Do you need to have a blog in order to use WordPress for a site?

255

Who are non resident?

1157

How do I know if the track changes tool is turned on in ms word?

684

What is the difference between the keyword view and expert view?

1018