Can this be used with internet forms?

[Lukey]

Hi,

I have many processes where I'd like to extract data from Excel and enter it into various web forms, move to the next Excel row and repeat.

Is this a product that can do that?

thanks,
Luke

[Gintaras]

Example

Code:

Copy      Help

act " Internet Explorer"
ARRAY(str) a
foreach a "" FE_ExcelRow
,Htm el=htm("INPUT" "as_q" "" " Internet Explorer" 0 0 0x221 5)
,el.SetText(a[0])
,el=htm("INPUT" "as_epq" "" " Internet Explorer" 0 3 0x221)
,el.SetText(a[1])
,el=htm("INPUT" "as_oq" "" " Internet Explorer" 0 4 0x221)
,el.SetText(a[2])
,el=htm("INPUT" "as_eq" "" " Internet Explorer" 0 5 0x221)
,el.SetText(a[3])
,1
,;el=htm("INPUT" "Google Search" "" " Internet Explorer" 0 2 0x421)
,;el.Click
,;5
,;web "Back"


This macro gets data from currently active Excel sheet, which has at least 4 columns, and populates Google advanced search form (http://www.google.com/advanced_search?hl=en) in Internet Explorer. Repeats for each row, every 1 second. You need Quick Macros version 2.1.7 or later. Use the "Find html element" dialog to capture form elements you need (it inserts htm function).

[Lukey]

OK, thanks for the fast response.

Luke