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  

---

How can you have different number of cells for each row of a table in HTML?

2 Answers  

---

int a=4857 i need output as 7584.without using any inbuild function?

6 Answers   Aspire,

---

Which date function is used in the vbscript language to find the difference between the 2 dates?

0 Answers  

---

If we take 2 strings as “good” and “bad” then what will ‘+’ and ‘&’ operators return?

0 Answers  

---

What is the difference between vbscript and vba?

0 Answers  

---

write a vb script to rename a folder from tree4 to tree7

3 Answers  

---

create a form to accept username and password validate the username and password with using message box, display the corresponding user message

0 Answers   CSC,

---

Which conditional statement is the most convenient one to use in the case of multiple conditions in the vbscript language?

0 Answers  

---

What is select case statement?

0 Answers  

---

Explain a few date functions in vbscript

0 Answers  

---

hey please tell me how to retriev data from excel sheet which puts the login name and password in the application? plz send me the code..please help me

6 Answers   HP,

---