Answer Posted / pratap19901990
yes,
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Explain about tristate constants?
How to write functions and sub in vb script?
how to comvert 120 into one hunderd twenty rupees only and vice varsa
Please let me Know regarding any material regarding VB Scripting which should be easily understandable for Beginners.
what is event handling?
Explain about filter expression?
Why is it recommended to close the database connection every time after the work is completed?
What are the special sub-types in vbscript?
What purpose does ‘on error resume next’ serves?
Why to use option explicit in vb script?
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
Mention how to access array data?
How to replace junk code recorded by QTP with a mall function.
How to open a file. What is the perpose of true and false mode there?
How to open excel in vb script?