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
...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.
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.