Insert date using datepicker in selenium VBA

Question

Using selenium VBA, I am uploading some data and there is a date which I need to insert using datepicker. Here's the html of the webpage that has the datepicker https://pastebin.com/yqf8H36k

I tried to use SendKeys to send the date directly but the datepicker popup appeared and nothing entered.

.FindElementById("date").SendKeys wsUpload.Range("B5").Value
.FindElementById("date").Click
Debug.Print .FindElementByXPath("//div[@role='period']").Attribute("innerHTML")
.FindElementByXPath("//div[@role='period']").Click

Any ideas...?

getdatepicker.com/4 , stackoverflow.com/a/40367539, stackoverflow.com/a/59761118 — QHarr
– QHarr, Commented Dec 10, 2020 at 17:53
^^ you have a bootstrap datepicker like link 1 in comment above. The second two links show how to "cheat" programmatically interact with it and inject your date. The format for the jquery part depends on what the format is for your datepicker. — QHarr
– QHarr, Commented Dec 10, 2020 at 17:54
I have no great idea about bootstrap. How can I get the link to the datepicker? — YasserKhalil
– YasserKhalil, Commented Dec 10, 2020 at 17:58
I put a link above you can use for demo (just scroll down the page - there's a date only section) — QHarr
– QHarr, Commented Dec 10, 2020 at 17:59

YasserKhalil · Accepted Answer · 2020-12-10 17:47:57Z

1

I could find some java scripts that leads me to the solution

Dim dt As Object
Set dt = .FindElementByCss("input#date")
.ExecuteScript "window.scrollBy(0, 400)"
.ExecuteScript "arguments[0].removeAttribute('readonly')", dt
dt.Clear
dt.SendKeys wsUpload.Range("B5").Value
.SendKeys .Keys.Tab

And another easier solution

.ExecuteScript "document.getElementById('date').value = '" & wsUpload.Range("B5").Value & "'"

edited Dec 10, 2020 at 17:47

answered Dec 10, 2020 at 17:41

YasserKhalil

9,60813 gold badges62 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

QHarr Over a year ago

^^ or that :-) works. I am always suspicious of Excel when it comes to reading in dates from cells however.

YasserKhalil Over a year ago

Thanks a lot, my tutor.

Collectives™ on Stack Overflow

Insert date using datepicker in selenium VBA

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related