How do display output message without using msgbox function?

5 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

0 Answers  

---

When are redim statement and preserve keyword used in the vbscript language?

0 Answers  

---

What are the different types of operators and their order of precedence?

0 Answers  

---

Explain about adodb.stream class?

0 Answers  

---

How to make sure that items in a wintree are sorted al?

0 Answers   Ness Technologies,

---

How do you write an SQL insert statement?

4 Answers   HCL,

---

Why to use option explicit in vb script?

0 Answers  

---

What is vbscript?

0 Answers  

---

What is the use of "Option Explicit"?

2 Answers  

---

How to capture a runtime error in vbscript?

0 Answers  

---

Explain the arrays in vb script?

0 Answers  

---