Hi there, I've got a .vbs file with 127 lines of code and it takes about 6-7 seconds for the program to finish and I don't want people to 2x click again and again because they wouldn't be patient enough to wait 7 seconds (and they could also belive that they didn't activate it properly first time round so they'd click again on the file.... Slowing the process even more.
So is there a way to make a progress bar that would open as soon as you open the file and thet would increase as the program is running? I'd like the progress bar to increase as the info is gathered (1 paragraph - after the http adresses - is 1 info).
Here's the code:
'===================
strArchitectPg1 = "
http://www.irishjobs.ie/showresults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=96&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0"
strArchitectPg2 = "
http://www.irishjobs.ie/ShowResults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=96&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0&page=2"
strArchTechPg1 = "
http://www.irishjobs.ie/showresults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=3094&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0"
strArchTechPg2 = "
http://www.irishjobs.ie/ShowResults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=3094&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0&page=2"
strArchTechnoPg1 = "
http://irishjobs.ie/showresults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=97&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0"
strArchTechnoPg2 = "
http://irishjobs.ie/ShowResults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=97&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0&page=2"
strAutoCadPg1 = "
http://irishjobs.ie/showresults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=2917&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0"
strAutoCadPg2 = "
http://irishjobs.ie/ShowResults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=2917&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0&page=2"
strGraphicDespg1 = "
http://irishjobs.ie/showresults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=4501&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0"
strIntDesPg1 = "
http://irishjobs.ie/showresults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=3340&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0"
strIntDesPg2 = "
http://irishjobs.ie/ShowResults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=3340&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0&page=2"
strLandArchPg1 = "
http://irishjobs.ie/showresults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=102&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0"
strProjArchPg1 = "
http://irishjobs.ie/showresults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=3129&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0"
strProjArchPg2 = "
http://irishjobs.ie/ShowResults.aspx?referrer=local&Company=ON&Agency=ON&Location=&Category=9&Roles=3129&IsProvince=1&MatchPerc=40&Ranking=6&JobType=0&No_Days_Created=0&page=2"
Set objHTTP = CreateObject("MSXML2.XMLHT
TP")
objHTTP.Open "GET", strArchitectPg1, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intArchPg1Count = UBound(arrText)/2
objHTTP.Open "GET", strArchitectPg2, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intArchPg2Count = UBound(arrText)/2
objHTTP.Open "GET", strArchTechPg1, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intArchTechPg1Count = UBound(arrText)/2
objHTTP.Open "GET", strArchTechPg2, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intArchTechPg2Count = UBound(arrText)/2
objHTTP.Open "GET", strArchTechnoPg1, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intArchTechnoPg1Count = UBound(arrText)/2
objHTTP.Open "GET", strArchTechnoPg2, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intArchTechnoPg2Count = UBound(arrText)/2
objHTTP.Open "GET", strAutoCadPg1, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intAutoCadPg1Count = UBound(arrText)/2
objHTTP.Open "GET", strAutoCadPg2, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intAutoCadPg2Count = UBound(arrText)/2
objHTTP.Open "GET", strGraphicDespg1, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intGraphicDesPg1Count = UBound(arrText)/2
objHTTP.Open "GET", strIntDesPg1, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intIntDesPg1Count = UBound(arrText)/2
objHTTP.Open "GET", strIntDesPg2, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intIntDesPg2Count = UBound(arrText)/2
objHTTP.Open "GET", strLandArchPg1, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intLandArchPg1Count = UBound(arrText)/2
objHTTP.Open "GET", strProjArchPg1, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intProjArchPg1Count = UBound(arrText)/2
objHTTP.Open "GET", strProjArchPg2, FALSE
objHTTP.Send
strPageText = objHTTP.responseText
arrText = Split(strPageText, "Big Fish Recruitment")
intProjArchPg2Count = UBound(arrText)/2
Set objHTTP = Nothing
MsgBox "Architect - Page 1 Count: " & intArchPg1Count & VbCrLf & _
"Architect - Page 2 Count: " & intArchPg2Count & VbCrLf & _
"-------------------------
----------
---------"
& VbCrLf & _
"Architectural Technician - Page 1 Count: " & intArchTechPg1Count & VbCrLf & _
"Architectural Technician - Page 2 Count: " & intArchTechPg2Count & VbCrLf & _
"-------------------------
----------
---------"
& VbCrLf & _
"Architectural Technologist - Page 1 Count: " & intArchTechnoPg1Count & VbCrLf & _
"Architectural Technologist - Page 2 Count: " & intArchTechnoPg2Count & VbCrLf & _
"-------------------------
----------
---------"
& VbCrLf & _
"Autocad Technician - Page 1 Count: " & intAutoCadPg1Count & VbCrLf & _
"Autocad Technician - Page 2 Count: " & intAutoCadPg2Count & VbCrLf & _
"-------------------------
----------
---------"
& VbCrLf & _
"Graphic Designer - Page 1 Count: " & intGraphicDesPg1Count & VbCrLf & _
"-------------------------
----------
---------"
& VbCrLf & _
"Interior Designer - Page 1 Count: " & intIntDesPg1Count & VbCrLf & _
"Interior Designer - Page 2 Count: " & intIntDesPg2Count & VbCrLf & _
"-------------------------
----------
---------"
& VbCrLf & _
"Landscape Architect - Page 1 Count: " & intLandArchPg1Count & VbCrLf & _
"-------------------------
----------
---------"
& VbCrLf & _
"Project Architect - Page 1 Count: " & intProjArchPg1Count & VbCrLf & _
"Project Architect - Page 2 Count: " & intProjArchPg2Count & VbCrLf & _
"-------------------------
----------
---------"
'===================
Start Free Trial