Excel variable use in macro

[AMIPIERRE]

Hi
My original question was: In a Web page where I cannot paste a value from Excel, how can I make a choice in that rectangle from a cell.value?

Thank.

[hagchr]

Hi, just before saving I note the original question has been removed, however, here is what I would have suggested. Hopefully it still helps. Depending on the web site and what you want to do you may want to check MS tools to interact with web pages if there is a better way.

//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
  View Snippet Page

[Marcus Tettmar]

Please don't remove questions. It removes any sense from the thread. Now we have a thread with an answer but no question. One of the main benefits and purposes of a forum is to help EVERYONE - not just the original posted. With the original question intact, other people's responses make sense and the thread may be useful to others. Even if you've already found the answer, it still pays to leave the original post. By all means reply to your own post with the solution. That will also help people.

[AMIPIERRE]

Thanks hagchr. It's another way that gives me good lesson.

The way I solved, for the beginner I am, is like this:

In the webpage, there's that place where I have to chose between five entries. In my Excel Workbook, I use those names and I associated the right number of click down to each name. That number becomes a variable in MS.

// ROLE

SetFocus>Microsoft Excel (Name of the Workbook)
wait>0.5
'Name the value from cell A5 in SHEET1
XLGetCell>XLBook,sheet1,1,5,ROLEnb
wait>0.5
'Return to the Webpage where, using the keyboard, I stand at the right rectangle
SetFocus>Webpage - Internet Explorer
wait>0.5
press down * %ROLEnb%
press Enter

Apologies Marcus