Automating with Internet Explorer

This might work for you:

Hi Andrew,

I tried bit it doesn't work.I get this error with submit highlighted:

Object variable or With Block variable not set.

Also I tried looking for 'Submit' under the forms.item1 hierarchy in the AddWatch window and couldn't find it.

thanks for your suggestion.

Sarah

It's hard to help with this sort of thing without seeing some actual code and/or the URL you are trying to work with.

I would also wonder if this new InternetExlorer is a new version of the much maligned InternetExplorer.

Sorry Norie,

It's not feasible for me to post the URL because it is a private website and also because it requires you to login.

The layout if the page is similar to a page where you are required to log-in,ie There's a textbox for username and password and a button called submit.

I manage to get the input unto the textbox by appending to the URL the details eg http//:www.websitename.com/usersame=A&password=B.

that link brings you to a page where you are required to confirm what you just entered by clicking on the 'submit' button.I tried to get the link of the submit button but in won't show on IE's status bar.

the reference that I use is the one that belongs to SHDocVw;
C:\WINDOWS\system32\ieframe.dll
Microsoft Internet Controls

Is this the 'maligned version' you are talking about.I am willing to use other browser eg Firefox if I can get my hands on sufficient documentation.

Thanks.

Norie is talking about the absence of a p in InternetExlorer.

oops...didn't realise my typo!

it's actually InternetExplorer

In the past I've found IMacros extremely useful for identifying the names of controls for which the underlying code is unavailable.

So does this work?

Hello,

Andrew,the code still dosen't work.My post my contained a typo but my code certainly did not . I still couldn't find the member '.Submit' in the Add Watch hierarchy.

ScottR,I find IMacros very helpful.Thanks for introducing it to me.Unfortunately,I could'nt understand the code.(I'm only familiar with C++ and VB)

I was thinking of having excel modify the .iim file as and when necessary and then have IE execute the macro.

I think I am able to modify the file,but I can't figure out how to have IE execute it.Any suggestions?

Thank You Very Much!