Here is the python script to input values to text and click submit button and I want to convert it to excel VBA. The conversation did not work, so need a working code:
<code>from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
import time
driver = webdriver.Remote(
command_executor='http://localhost:4444/wd/hub',
options=webdriver.ChromeOptions(),
)
driver.maximize_window()
driver.implicitly_wait(10)
URL = "https://www.nepsealpha.com/nepse-data"
driver.get(URL)
time.sleep(5)
date_start = driver.find_element(By.CSS_SELECTOR, "input[min='2019-05-28']")
date_start.send_keys("01/01/2020")
date_start.send_keys(Keys.ENTER)
date_end = driver.find_element(By.CSS_SELECTOR, "input[max='2024-05-28']:not([min])")
date_end.send_keys("01/01/2021")
date_end.send_keys(Keys.ENTER)
time.sleep(10)
driver.quit()
</code>
<code>from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
import time
driver = webdriver.Remote(
command_executor='http://localhost:4444/wd/hub',
options=webdriver.ChromeOptions(),
)
driver.maximize_window()
driver.implicitly_wait(10)
URL = "https://www.nepsealpha.com/nepse-data"
driver.get(URL)
time.sleep(5)
date_start = driver.find_element(By.CSS_SELECTOR, "input[min='2019-05-28']")
date_start.send_keys("01/01/2020")
date_start.send_keys(Keys.ENTER)
date_end = driver.find_element(By.CSS_SELECTOR, "input[max='2024-05-28']:not([min])")
date_end.send_keys("01/01/2021")
date_end.send_keys(Keys.ENTER)
time.sleep(10)
driver.quit()
</code>
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
import time
driver = webdriver.Remote(
command_executor='http://localhost:4444/wd/hub',
options=webdriver.ChromeOptions(),
)
driver.maximize_window()
driver.implicitly_wait(10)
URL = "https://www.nepsealpha.com/nepse-data"
driver.get(URL)
time.sleep(5)
date_start = driver.find_element(By.CSS_SELECTOR, "input[min='2019-05-28']")
date_start.send_keys("01/01/2020")
date_start.send_keys(Keys.ENTER)
date_end = driver.find_element(By.CSS_SELECTOR, "input[max='2024-05-28']:not([min])")
date_end.send_keys("01/01/2021")
date_end.send_keys(Keys.ENTER)
time.sleep(10)
driver.quit()
Need a working code in excel VBA for the same
1