473,322 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Automating Internet Explorer from MS Access

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.
Mar 15 '07 #1
4 3160
willakawill
1,646 1GB
Moved your thread to the access forum
Mar 16 '07 #2
nico5038
3,080 Expert 2GB
I've used in the past the code from:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=58524&lngWId=1

This will get the selected text and thus save the copy/paste for the user.

The HTMLDocument will allow the manipulation of the fields, but I've not experimented with that yet...

Nic;o)
Mar 17 '07 #3
Denburt
1,356 Expert 1GB
If I were you I would do my best to try a more direct approach, If this is on your companies intranet find out the type of database, location etc. and get the data that way. If it is on the internet maybe you could contact the company and get them to set up an XML file.

If you really want to or have the need to root through the webpage remember any names or ID they are using today might change tomorrow. This said I have a ton of code used to interface with WebPages, from a previous project, however it is at home at the moment. I will gladly dig it up when I get there but I may be able to get you started, if I am not mistaken it would be something to the effect of:

Expand|Select|Wrap|Line Numbers
  1. Set myPage = Application.FollowHyperlink(Address, SubAddress, NewWindow, AddHistory, ExtraInfo, Method, HeaderInfo)
From there you should be able to refer to the elements on the page using the object myPage.

Hope this helps!
Mar 19 '07 #4
Thanks to all, and sorry I've been incommunicado. I tried the above listed tips, and quickly moved into territory that is beyond my skill scope. So, I figured out that the web app is actually calling some other software that is also available to me through my company and will attempt to engineer the whole procedure by executing the software directly, instead of through the intranet site.

I appreciate the time taken to reply to me, and hope that it wasn't too much!

Many thanks!
Apr 3 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

12
by: SunshineGirl | last post by:
I'm trying to receive events from a running instance of Internet Explorer. So far I've only been able to receive events from an instance I launch from code, but I need to receive events from all...
3
by: Mark | last post by:
Hi all, Im written a small javascript program. Once it finishs I want to close the internet explorer page. I have used window.close(); when this runs it pops up with a Internet Explorer Dialog...
6
by: tinkerman | last post by:
Hello net friends, I need to automate Internet Explorer in a very simple way. I need to: 1. press refresh (F5) on the currently loaded website. 2. press END button. 3. Click a button...
2
by: Jax | last post by:
I am interested in finding out if it is possible with C# to manipulate IE to go to certain websites and act as a user I basically have a process I wish to automate but this process requires the...
10
by: milk-jam | last post by:
I'm trying to write a log which save each time internet explorer is opened or closed and all of the url which where visited? Any help is greatly appreciated.
3
by: ewhite2142 | last post by:
I am writing code in VB.Net to access data from the Internet. If I write the following code, I get access to a new instance of Internet Explorer: Imports SHDocVw Dim Br as New InternetExplorer...
1
by: chris_j_adams | last post by:
Hi, I'm trying to use Excel VBA ('97) to send details from an Excel sheet to a web page. I'm having some success but I've one issue that's proved difficult to find in the archives. There are...
3
by: Matthew Lock | last post by:
Hello, I am automating Internet Explorer in order to do some simple automated testing of a web application. How do I invoke Javascript functions in the web page I load? I can successfully start...
26
by: Prisoner at War | last post by:
Hi, All: I have a JavaScript search engine that always causes MSIE 7 to do a top-of-page security "warning" (that top-of-page-bar, and not an "alert" )...but other websites' JavaScripts do not...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.