CaptainGiblets
asked on
Pasting information in to Internet explorer from Access
I know you can screen scrape from IE in to access / excel, however is there a way to reverse the process?
For example, a web page has 30 text boxes on it, can i paste data into the text boxes by using VBA?
For example, a web page has 30 text boxes on it, can i paste data into the text boxes by using VBA?
Yes. You can use the DOM (Document Object Model) to access web page items by name, id, class, or iteration. Once found, you can retrieve/assign their values
ASKER
Do you have any examples of how to do this? I did a search this morning but all I could find was how to scrape the information down.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It looks like it might not be compatible with IE 9+?
Everything I can see says its DLL's but ive installed VB6 run time.
Everything I can see says its DLL's but ive installed VB6 run time.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.