Link to home
Start Free TrialLog in
Avatar of CaptainGiblets
CaptainGibletsFlag for United Kingdom of Great Britain and Northern Ireland

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?
Avatar of aikimark
aikimark
Flag of United States of America image

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
Avatar of CaptainGiblets

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
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial