Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Can this be used with internet forms?
#1
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
#2
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).
#3
OK, thanks for the fast response.

Luke


Forum Jump:


Users browsing this thread: 1 Guest(s)