Greetings:
I'm looking for some help in automating (what I thought would be) a simple procedure in Internet Explorer. I'm trying to put the following operation under a button click in an MS Access database form:
1. Navigate to URL and click button
2. Enter user name and password
3. Apply filters (enter criteria in text boxes)
4. Execute query (another button click)
5. Export results to network server
6. Data mining using Monarch software
7. Export to Access
8. Run Attachmate macro to input data to mainframe system
I am not a legitimate programmer, but have had some success in picking up vb(a) over the years just by using the help topics in the vb editor in MS Access modules. Remarkably, I've figured out items 1, 6, 7, and 8 myself. I think if I could just get some help with code that would enumerate the names or tags or ids of the elements on the web page, I could finish 2 - 5.
Can anyone provide vb code using the Microsoft Internet Explorer references library, and/or the Microsoft HTML references library that would show me a list of the elements on a web document? An example of how to use getElementbyId or TagName (or your own better idea) to perform subsequent text and click operations would also be handy.
Much obliged! This code is going to save hours and hours of repetetive data manipulation every week for an office of about 200 people.