Website autofill

**Aidanb** · 08-26-2008, 06:25 PM

Hi all,

I am wanting some help on a little problem if i can be done that is?.

i am wanting to create a hperlink button that will goto a website and autoinput login information in to the relevant boxes on a banks website the thing is that the 4 digit code required randomly generates 2 leters from its self i know this will be an if statement in VBA e,g
if number one requested then
inputbox="1"
elseif Number two requested then
inputbox="2"

and so on but how would this be achieved in a website i have all names of the input boxes and the buttons that need to be selected to proceed to the next page.

Strange request i know but something i am trying to work on for myself.

All help appriciated

Regards

Aidan

**dominicb** · 08-27-2008, 04:35 AM

Good morning Aidanb

...and welcome to the forum!!

To extract any two digits from a four digit string is simplicity itself - you don't even need an if statement. One line for each of the two digits is all that's needed using a mid statement. The tricky bit is identifying which two digits the site is asking for - if you can identify this (and I can't tell you how to do this, don't even know if it's possible to via VBA) then you're laughing.

Now the caveat : do you really want to store this kind of sensitive information in Excel? I wouldn't. The strength of protection the Excel offers is woefully pitiful and can be broken in seconds by anyone in the know. If anyone gets access to your computer, or even just that file without your knowledge you're leaving yourself wide open to a lot of heartache ...

HTH

DominicB

**Aidanb** · 08-27-2008, 09:00 AM

Hi DominicB,

Thanks for the welcome and the response.

I understand what you are saying with the security but then its only going to be used from my computer not in other places so just want a quick and easy way to check my bank accounts maybe even try and download figures at a later date will see how much time i have to play heehee.

the web page has in its source code the information that is required its just how do we retrive this information from the web site and then automatically input in the web page.

any information you require such as the source code from the web site then let me know.

Thank you

Aidan

**dominicb** · 08-27-2008, 09:42 AM

Hi Aidanb

Although the HTML portion of the website's source may be viewable, the random number will not be a static number that can be picked up. A random number (or, in this instance, two random numbers) would be generated in one of two ways :

By a computer program "behind-the-scenes" and a number is then passed to the site as a variable to be displayed (most probable way);
By using javascript to generate the random numbers in realtime as the HTML is run : the Math.random() construct can be used for this.

Either way, the sourec code will not show the number that is displayed on screen, and while banks may allow bank details to be downloaded in Excel format, I would be very surprised if they made it simple for users to connect directly to the bank bypassing security measures for very obvious reasons.

DominicB

**Aidanb** · 08-27-2008, 10:24 AM

Hi,

Would it be possible to check on an as and when basis for the two codes required instead of having to mathamatically or randomly work out these.

<tr>
<td class="label"><label for="firstPassCodeDigit">first digit:  </label></td>
<td class="field">
<select name="firstPassCodeDigit" onmousedown="g_bTabEnabled=true;" onkeydown="appearMaskedOne(this,event);" onchange="appearMaskedOne(
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option></select>
</td>
</tr>
<tr>
<td class="label"></td>
https://welcome23.smile.co.uk/SmileWeb/login.do view-source:https://welcome23.smile.co.uk/SmileWeb/login.do

<td class="error"></td>
</tr>
<tr>
<td><br>
</td>
</tr>
<tr>
<td class="label"><label for="secondPassCodeDigit">fourth digit:  </label></td>
<td class="field">
<select name="secondPassCodeDigit" onmousedown="g_bTabEnabled=true;" onkeydown="appearMaskedTwo(this,event);" onchange="appearMaskedTwo
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option></select>

this is what the source code is for this section the underlined text is the call option for the number is there any way this could be checked then the number inserted in to the relevant box??.

Aidan