DavidLee91
07-01-2015, 07:18 PM
Hi Folks,
I am still a beginner in my VBA programming and would really appreciate any help or if you could point me to a direction.
I am currently required to use VBA to go to a website and tick a checkbox if the requirement are met. For example, the website contains the following list of field:
Checkbox ----------------ID ---------------------Name
box -------------------12345 --------------ABC Corporation
box -------------------51234 --------------XYZ Corporation
.... ..... .....
I am required to find ABC Corporation with ID 12345 in this website and tick the checkbox. Bottom is a snapshot of the HTML code. I believe the website is coded in asp.
PS: I am able to use VBA sendkeys function to login and reach to the necessary page. However, SendKeys no longer powerful enough to do this requirement for me! :crying:
.....
</td><td width=22 height=1><p><input type=checkbox name=CheckList value="12345"></p></td><td width=2 height=1>12345</td><td width=539 height=1>ABC Corporation</td><td width=1 height=1>C</td><td width=100 height=1>-</td>
</td><td width=22 height=1><p><input type=checkbox name=CheckList value="51234"></p></td><td width=2 height=1>51234</td><td width=539 height=1>XYZ Corporation</td><td width=1 height=1>C</td><td width=100 height=1>-</td>
.....
I would really appreciate if anybody can enlighten me as I am totally clueless how I can achieve this! : pray2:
Thanks!
David
I am still a beginner in my VBA programming and would really appreciate any help or if you could point me to a direction.
I am currently required to use VBA to go to a website and tick a checkbox if the requirement are met. For example, the website contains the following list of field:
Checkbox ----------------ID ---------------------Name
box -------------------12345 --------------ABC Corporation
box -------------------51234 --------------XYZ Corporation
.... ..... .....
I am required to find ABC Corporation with ID 12345 in this website and tick the checkbox. Bottom is a snapshot of the HTML code. I believe the website is coded in asp.
PS: I am able to use VBA sendkeys function to login and reach to the necessary page. However, SendKeys no longer powerful enough to do this requirement for me! :crying:
.....
</td><td width=22 height=1><p><input type=checkbox name=CheckList value="12345"></p></td><td width=2 height=1>12345</td><td width=539 height=1>ABC Corporation</td><td width=1 height=1>C</td><td width=100 height=1>-</td>
</td><td width=22 height=1><p><input type=checkbox name=CheckList value="51234"></p></td><td width=2 height=1>51234</td><td width=539 height=1>XYZ Corporation</td><td width=1 height=1>C</td><td width=100 height=1>-</td>
.....
I would really appreciate if anybody can enlighten me as I am totally clueless how I can achieve this! : pray2:
Thanks!
David