asked on Using VBA, Manipulating Internet Explorer and importing data
Using Excel VBA, I want to
open an explorer window (done),
navigate to the url (done)
find a hyper link and click on it (not done).
open an explorer window (done),
navigate to the url (done)
find a hyper link and click on it (not done).
Please see the file attached. go to the codes in vba
Visual Basic Classic
Last Comment
ThatDeadDude
Look at the source for the page open in IE at that time. "Construction Inspection Project Inventory" isn't a link - it's a form input that for whatever reason has been made to look like a link. You'll need to change your code to look for an INPUT tag with a value of "Construction Inspection Project Inventory" instead of an A tag.
ASKER
That's what i have found out. it is not href.
Since i am green to this, could you tell me what the following shoul look like. and what to click.
If IE.Document.All(i).tagname
IE.Document.All(i).Click
Also, could you tell be how to use the following to make it efficient.
ie.Document.getelementbyid
Thank you.
Since i am green to this, could you tell me what the following shoul look like. and what to click.
If IE.Document.All(i).tagname
IE.Document.All(i).Click
Also, could you tell be how to use the following to make it efficient.
ie.Document.getelementbyid
Thank you.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.