Uploaded December 2021 | Updated November 2026, 12 hours ago
How to automate data entry with Chrome using Excel macros and Selenium. Details available at exceltrainingvideos.com/automate-data-entry-with-chrome-using-excel-macros
Here's the complete VBA macro code:
Option Explicit
Dim driver As New WebDriver
Sub Test()
Dim keys As New SeleniumWrapper.keys
driver.Start "chrome"
driver.Get "ssg2021.in/CitizenFeedback\"
driver.Window.Maximize
driver.Wait 1000
driver.FindElementById("State").Click
driver.FindElementById("State").SendKeys Sheet1.Cells(2, 1).Value
driver.Wait 1000
driver.FindElementById("District").Click
driver.FindElementById("District").SendKeys Sheet1.Cells(2, 2).Value
driver.Wait 1000
driver.SendKeys (keys.Enter)
driver.FindElementByName("RespondentAge").SendKeys Sheet1.Cells(2, 3).Value
driver.Wait 1000
driver.FindElementByName("RespondentName").SendKeys Sheet1.Cells(2, 4).Value
driver.Wait 1000
driver.FindElementByName("RespondentMobileNo").SendKeys Sheet1.Cells(2, 5).Value
driver.Wait 1000
driver.FindElementByName("RespondentGender").Click
driver.Wait 1000
driver.FindElementByName("RespondentGender").SendKeys Sheet1.Cells(2, 6).Value
driver.Wait 1000
driver.FindElementByClass("btn-primary").Click
'driver.SendKeys (keys.Enter)
driver.FindElementByName("FQ1").Click
driver.FindElementByName("FQ1").SendKeys Sheet1.Cells(2, 7).Value
driver.Wait 1000
driver.FindElementByName("FQ2").Click
driver.FindElementByName("FQ2").SendKeys Sheet1.Cells(2, 8).Value
driver.Wait 1000
driver.FindElementByName("FQ3").Click
driver.FindElementByName("FQ3").SendKeys Sheet1.Cells(2, 9).Value
driver.Wait 1000
driver.FindElementByName("FQ4").Click
driver.FindElementByName("FQ4").SendKeys Sheet1.Cells(2, 10).Value
driver.Wait 1000
driver.FindElementByName("FQ5").Click
driver.FindElementByName("FQ5").SendKeys Sheet1.Cells(2, 11).Value
driver.Wait 1000
driver.SendKeys (keys.Enter)
End Sub
How to automate data entry with Chrome using Excel macros and Selenium. Details available at exceltrainingvideos.com/automate-data-entry-with-chrome-using-excel-macros
Here's the complete VBA macro code:
Option Explicit
Dim driver As New WebDriver
Sub Test()
Dim keys As New SeleniumWrapper.keys
driver.Start "chrome"
driver.Get "ssg2021.in/CitizenFeedback\"
driver.Window.Maximize
driver.Wait 1000
driver.FindElementById("State").Click
driver.FindElementById("State").SendKeys Sheet1.Cells(2, 1).Value
driver.Wait 1000
driver.FindElementById("District").Click
driver.FindElementById("District").SendKeys Sheet1.Cells(2, 2).Value
driver.Wait 1000
driver.SendKeys (keys.Enter)
driver.FindElementByName("RespondentAge").SendKeys Sheet1.Cells(2, 3).Value
driver.Wait 1000
driver.FindElementByName("RespondentName").SendKeys Sheet1.Cells(2, 4).Value
driver.Wait 1000
driver.FindElementByName("RespondentMobileNo").SendKeys Sheet1.Cells(2, 5).Value
driver.Wait 1000
driver.FindElementByName("RespondentGender").Click
driver.Wait 1000
driver.FindElementByName("RespondentGender").SendKeys Sheet1.Cells(2, 6).Value
driver.Wait 1000
driver.FindElementByClass("btn-primary").Click
'driver.SendKeys (keys.Enter)
driver.FindElementByName("FQ1").Click
driver.FindElementByName("FQ1").SendKeys Sheet1.Cells(2, 7).Value
driver.Wait 1000
driver.FindElementByName("FQ2").Click
driver.FindElementByName("FQ2").SendKeys Sheet1.Cells(2, 8).Value
driver.Wait 1000
driver.FindElementByName("FQ3").Click
driver.FindElementByName("FQ3").SendKeys Sheet1.Cells(2, 9).Value
driver.Wait 1000
driver.FindElementByName("FQ4").Click
driver.FindElementByName("FQ4").SendKeys Sheet1.Cells(2, 10).Value
driver.Wait 1000
driver.FindElementByName("FQ5").Click
driver.FindElementByName("FQ5").SendKeys Sheet1.Cells(2, 11).Value
driver.Wait 1000
driver.SendKeys (keys.Enter)
End Sub




![Automatically Find First and Last Working Day in Month
How to automatically find first and last working day in any month using VBA.
Below is the recorded and optimized code:
Option Explicit
Sub FirstLastWorkingDayInMonth()
FirstLastWorkingDayInMonth Macro
How to find the first and last working day in a month given any date of the month
Range(A2).Select
ActiveCell.FormulaR1C1 = First working Day
Range(C2).Select
ActiveCell.FormulaR1C1 = _
=WORKDAY(DATE(YEAR(R[-1]C),MONTH(R[-1]C),1)-1,1,RC[2]:R[3]C[2])
Range(C2).Select
Selection.NumberFormat = m/d/yyyy
Range(E2).Select
Selection.ClearContents
Range(E2).Select
ActiveCell.FormulaR1C1 = 1-Jan-2020
Range(A3).Select
ActiveCell.FormulaR1C1 = Last Working Day
Range(C3).Select
ActiveCell.FormulaR1C1 = _
=WORKDAY(DATE(YEAR(R[-2]C),MONTH(R[-2]C)+1,1)-1,R[-1]C[2]:R[2]C[2])
Range(C3).Select
ActiveCell.FormulaR1C1 = _
=WORKDAY(DATE(YEAR(R[-2]C),MONTH(R[-2]C)+1,1),-1,R[-1]C[2]:R[2]C[2])
Range(C3).Select
Selection.NumberFormat = m/d/yyyy
Range(C1).Select
ActiveCell.FormulaR1C1 = 1/15/2020
Range(E3).Select
ActiveCell.FormulaR1C1 = 1/31/2020
Range(E3).Select
ActiveCell.FormulaR1C1 = 1/26/2020
Range(K3).Select
Range(A2) = First Working Day
Range(C2) = =WORKDAY(DATE(YEAR(R[-1]C),MONTH(R[-1]C),1)-1,1,RC[2]:R[3]C[2])
Range(C2).NumberFormat = m/d/yyyy
Range(A3) = Last Working Day
Range(C3) = =WORKDAY(DATE(YEAR(R[-2]C),MONTH(R[-2]C)+1,1),-1,R[-1]C[2]:R[2]C[2])
Range(C3).NumberFormat = m/d/yyyy
End Sub Automatically Find First and Last Working Day in Month](https://i.ytimg.com/vi/EFE_PULYBKg/mqdefault.jpg)





