EXCEL VBA macro to take a snap of required area

[Kishornbn6]

Hello Guys,

I'm new to VBA and I'm trying to hit a certain link which has six drop downs and I've have select a text value for two drop downs and symbol (=,!=) for other two and text for last two drop downs and click on a button (search) and once refreshed take a snap shot of desired area and send it via outlook using VBA macro.

Can anyone help me.

As for now I'm just able to hit the link:

Sub Test_OpenFireFoxNewTab()
  OpenInFireFoxNewTab "https:// somelink"
End Sub

Sub OpenInFireFoxNewTab(url As String)
  Dim pathFireFox As String
  pathFireFox = "C:\Program Files (x86)\Mozilla Firefox\firefox.exe"
  If Dir(pathFireFox) = "" Then pathFireFox = "C:\Program Files\Mozilla Firefox\firefox.exe"
  If Dir(pathFireFox) = "" Then
    MsgBox "FireFox Path Not Found", vbCritical, "Macro Ending"
    Exit Sub
  End If
  Shell """" & pathFireFox & """" & " -new-tab " & url, vbHide
End Sub

Thank you in Advance