Answer Posted / pratap19901990
yes,
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
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 will you get the octal value of the given number in vbscript?
Mention the environments where vbscript could be run?
How can constants be declared in the vbscript language?
hi i am trying for testing job for 3+ experience(fake) can u suggest me what type of projects i can keep in my resume and how much of knoeledge i should have abt that project.thnks in advance.urgt plz
Mention what is variant in vbscript?
How to assign a numeric value to a variable?
Explain the tristate constants in vbscript?
What is the purpose of folders object of scripting.filesystemobject class in vbscript?
How to make sure that items in a wintree are sorted al?
Write a Script for ATM in QTP
What is byref and byval parameters in vbscript?
who will create the object?
What is variant in vb script?
where can i learn VB scripint ?