Automate Naukri.com from Excel VBA.

[kashif.special2005]

Hi,

I am trying to learn, that how can we automate internet explorer from excel vba, I am trying to automate Naukri.com from vba, and wrote some code to automate that, I achieved some part of the task, with below code.

Sub Naukri_Manipulation()
  
  Dim ie As InternetExplorer
  Dim HTMLDoc As MSHTML.HTMLDocument
  Dim elements As MSHTML.IHTMLElementCollection
  Dim element As MSHTML.IHTMLElement
    
  Set ie = New InternetExplorer
  
  ie.navigate "www.naukri.com"
  ie.Visible = True
  ie.Silent = False
  
  Do While ie.readyState <> READYSTATE_COMPLETE
    DoEvents
  Loop
  
  Set HTMLDoc = ie.document
  
  HTMLDoc.getElementsByName("qp").Item(0).Value = "VBA Developer"
  HTMLDoc.getElementsByName("ql").Item(0).Value = "Delhi Ncr"
  HTMLDoc.getElementById("exp_ddHid").Value = 3
  HTMLDoc.getElementById("salary_ddHid").Value = 4
  HTMLDoc.getElementById("qsbFormBtn").Click
  
  Do While ie.readyState <> READYSTATE_COMPLETE
    DoEvents
  Loop
  
'  For Each element In HTMLDoc.getElementsByClassName("content")
'    Debug.Print element.getAttribute("href")
'  Next element
  
End Sub

This code working fine, for input the value in the search boxes and click on "Search" button, after that I got lost, that how can we click each job details and grab the details.

Parameters

Skills, designation, companies:= VBA Developer
Location:= Delhi Ncr
Experience:= 3
Salary:= 4

Like if you pass parameter and click on "Search" button, the result will show, and after click on 1st link for output results, the below details need to grab.

Job Title:= Senior VBA Developer - MS Access

Company Name:=Oscillate Infotech Pvt. Ltd.
Experience:= 3-5 yrs
Location:= Noida
Job Description:=

• 3-5 years of experience with MS Access
• Experience with forms, reports, queries, modules, macro\'s, VBA
• Experience and high degree of confidence in general database theory and structure
• Experience with multiple versions of Access
• Experience with Excel and Excel VBA macro\'s
• Highly intelligent with ability to adapt and change

Desired Candidate Profile:=
Education-
UG: B.Tech/B.E.
PG:Post Graduation Not Required

Doctorate:Any Doctorate - Any Specialization, Doctorate Not Required

etc.,

Note:- Above type of information required for each searched output results.

Please help me to do this task.

Thanks
Kashif