Home Excel VBA Search button click
Reply: 0

Excel VBA Search button click

wei h
1#
wei h Published in 2018-01-12 16:27:28Z

Im having issues getting my search button to click after I pass in search values from my excel. Right now, the value successfully gets passed in, but the macro then breaks when search button needs to be clicked.

Code below:

ie.document.getElementById("searchbar").Value = var
'Here we are clicking on search Button
Set form = ie.document.getElementsByTagName("submitbtn")
Application.Wait (Now + TimeValue("0:00:02"))
Set button = form(0).submit
form(0).submit

Html:

   <input value="Submit" type="submit" id="submitbtn">
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.266795 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO