Simulating a carriage return while visiting an IE page in VBA

Algor_Langeaux

New Member
Joined
Aug 18, 2015
Messages
2
Short Version: I am trying to log into a device that has a web interface with Internet Explorer that requires a user action to enter to do webscraping.

The easiest action is a simple carriage return.

I have no clue how to make VBA functionally simulate a carriage return?

My situation requires using Excel 2000.

Slightly longer version:

The device (Sencore MRD 4400) forces a username/password entry whenever the device is activated via the HTML interface. However, since it is on a closed LAN no password has been set.

The focus is forced to the Password field by HTML on the page. Simply hitting return on the keyboard will get past the login.

There is no visible "Form" so

Code:
ie.Document.forms(0).Click

...does not work. Nor do any other variants I have tried.

There is a "Login" button, but it does not appear to trigger any sort of event directly... nor do any of it's associated layers. I have tried every single ID on the page to trigger an event and just keep getting errors. It doesn't seem to trigger any javascript code, so no joy there either. I have combed through all the .js code on the site/device, looked at attributes, and done everything but sacrifice a virgin to the project... but thus far, no joy.

Again... if I could only automate a carriage return I could get past this and get to the actual scraping bits... but I can't automate my way past that point.

Any help would be appreciated.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top