Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 2684 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What methods are used to create text files and open text files in the vbscript language?
Is vbscript language a case-sensitive language and what does it mean?
Give examples where vb script can directly run on users system with windows as os?
What is the event handling in vbscript?
What is byref and byval parameters in vbscript?
* ** *** Please write a code to get output like above diagram? ple explain as it how the code works?
Write a program using Java Script / VBscipt that checks if two matrices have identical values in all the elements
what is the object hyrarchy in QTP for a web based application
What are keywords in the vbscript language?
HOW TO OPEN NEW TAB USING VB SCRIPT IN QTP?
What are the valid scopes of a variable in vbscript?
What are the different types of operators and their order of precedence?
ASP 
