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
Difference between dim,public and private variables in vb script?
How are arrays declared in the vbscript language?
How to Import data from a file (file is on the desktop) to the data table
about vb scripting programs this type of all question& answers
wat is the com(common object model)object for mozilla firefox???????plz if any one know the exact answer....reply me......
Explain the string concatenation function in vbscript?
How will you get the octal value of the given number in vbscript?
what is used of Property........End Property loop ? how to write the script for it?
Give examples where vb script can directly run on users system with windows as os?
Which data type/types are supported by vbscript language and what are their specialties?
write any ttest cases using check points and parameterization
What's the difference between vbscript and vb.net?
Mention the environments where vbscript could be run?
If we take 2 strings as “good” and “bad” then what will ‘+’ and ‘&’ operators return?