Get variable from excel and press down v1

A Snippet from: hagchr

//Your excel sheet (check extension)
Let>tmp=C:\...\Classeur1.xlsx

//Open the excel file and read cell A1 in sheet feuil1 into the variable strCell
XLOpen>tmp,1,xlBook
XLGetCell>xlBook,feuil1,1,1,strCell

//Look for a number in strCell. NM gives number of numbers found, M_1 gives first one found etc
// \d+ is RegEx language meaning one or more digits, ie a number in this case. 
RegEx>\d+,strCell,0,M,NM,0

If>NM>0
    //You need to change this part
    //and set focus on the web page
    //you are working with etc.

    MessageModal>Number is: %M_1%    
    SetFocus>Microsoft Excel*
    Wait>1
    Press>Down *%M_1%    
Else
    MessageModal>No Number found
Endif

Select the code above to paste into your macro. Or: View Raw Text

Link: http://www.mjtnet.com/snip.htm?g=53e75c14318c6

Forum Embed Code - click to select all then copy (CTRL-C):
[snippet=53e75c14318c6]//Your excel sheet (check extension) Let>tmp=C:\...\Classeur1.xlsx //Open the excel file and read cell A1 in sheet feuil1 into the variable strCell XLOpen>tmp,1,xlBook XLGetCell>xlBook,feuil1,1,1,strCell //Look for a number in strCell. NM gives number of numbers found, M_1 gives first one found etc // \d+ is RegEx language meaning one or more digits, ie a number in this case. RegEx>\d+,strCell,0,M,NM,0 If>NM>0 //You need to change this part //and set focus on the web page //you are working with etc. MessageModal>Number is: %M_1% SetFocus>Microsoft Excel* Wait>1 Press>Down *%M_1% Else MessageModal>No Number found Endif[/snippet]
When pasting into the forum do NOT modify the script code or it will not match what is in the database - create a new snippet instead!