Here's a small challenge for those who have the ability:
I have a spreadsheet, the data of which must be checked several times a month. Each time I check the data I will have to check ten items. I know that there is a way to automatically fill in forms online from Excel using the webbrowsercontrol function. I have detailed what I need below:
Each time I use the checking system then I have to login on a webpage. The ID tags for the form and button are as below:
ID="txtLogin" - login
ID="txtPassword" - password
ID="ImageButton1" - login button
My login and password stay the same at all times
I am then directed to a second web page with a form to fill in. The id tags are as follows:
ID="Pin1" - a 12 digit code with letters and numbers
ID="DobDD1" - date of birth day (2 chars long)
ID="DobMM1" - date of birth month (2 chars long)
ID="DobYY1" - date of birth year (2 chars long)
The above values increase in number up to ten (e.g. the last number of each ID)
I then click a submit button to submit the data for checking. I am happy to click this last button manually.
Can someone please write me a shorth piece of code so that I can save many hours of typing in numerical data every month.
Thank you
Bookmarks