Need Help with Internet Form Fill (Part 1) !!!

[23izkool]

Hi all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have been at this problem for close to a year and finally got some headway but stuck at the last leg. Appreciate that someone can help me with this!
<o> </o>
OBJECTIVE OF THE MACRO (BASICALLY INTERNET FORM FILLING)<o></o>

• Open up multiple websites through the multiple weblinks recorded in a spreadsheet<o></o>
• Click the relevant buttons & copy some numerical figures from the spreadsheet into the websites, then click on the submit button in the websites to upload the figures<o></o>

<o> </o>PROBLEMS<o></o>

• Unable to write the macro to upload figures from the spreadsheet<o></o>
  • The fields to fill belong to ‘hidden input’ type<o></o>
  • Unable to access it like what was done for clicking edit button & submit button<o></o>
• Currently used an alternative à use ‘sendkeys method’ to (1) tab through the other fields in the website, (2) copy figures from the spreadsheet, (3) paste into the empty field which was tabbed to<o></o>
  • However, sendkeys are very unstable & sometimes tab to the wrong field!<o></o>

<o> </o>Will give more elaboration below!<o></o>
<o> </o>
<o></o>
ACTUAL WEB LAYOUT<o></o>
<o> </o>
(Fig 1 / Before clicking ‘Edit’ Button)
<o>

</o>

(Fig 3 / Key in empty fields & Click ‘Yes’ Button)
<o>

</o>

(Fig 4 / Figures will be populated to main screen à click ‘save’)
<o>

</o>
<o> </o>
THE SPREADSHEET DATA FROM WHICH FIGURES ARE PICKED TO FILL THE EMPTY FIELDS IN THE WEBSITE<o></o>
<o></o>

(Figure 5 / Table in Spreadsheet)
<o>

</o>
<o> </o>
<o> </o>So as I run the macro from the spreadsheet, it will:
(1) open up URL for Sector 1 à work within the webpage for Sector 1
a. click the green ‘Click here to edit’ button
b. click the red arrow to bring out the PopUp box (Red) for Branch1
c. fill in all the empty fields for Branch 1 (the empty fields for ‘Total Revenue’ & ‘Total Cost’)
d. click the green ‘Yes’ button à this will close the PopUp box & upload the figures to the empty fields (as in Fig 4)
e. click the green ‘Click here to save’ button (as in Fig 4)
(2) re-run the macro through a for-loop so that it repeats all the steps above to work on URL for Sector 2
<o> </o>
PROBLEMS<o></o>
· Without using sendkeys, I am unable to get the macro to upload the figures into the empty fields à the macro just stops & runs into errors because I do not know how to write to access the hidden input (I think)<o></o>
· Even when using sendkeys, it is very unstable à the macro updates the wrong figures, e.g. Total Revenue = 1 instead of 3 for Branch 1 (inputted the Total Cost instead). Using the above example, I am tabbing 6 times to get to the re<o></o>
· PLEASE HELP WITH THIS!!!!
· I have put in the relevant source code & the existing macro below. Hope someone can advise!

 

[23izkool]

Re: Need Help with Internet Form Fill (Part 2) !!!

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o>

</o>
<o>

</o>
<o>

</o>

 

[23izkool]

Hi all,

Pls ignore my other post. To the Administrators, kindly help me keep this post and delete the other (i'm willing to do the deletn but do not know how)

Hav manually converted e macro & source code to pic file as I could not get it pasted as per the 1st post. The posting seems to effect the source code itself & not as pure text in a forum posting.

In any case, spent a lot of time just posting this & really hope someone can shed some light on this. Will be happy to provide more details if necessary! Tks!