Launch Excel
Get first free row
Read from Excel C2 to C & %FirstFreeRow - 1% 'this is our list of hotels
Display select from list Dialog:
Here is what the result looks like:
This makes it so they can't make a bad selection.
Then, Read from Excel E & %SelectedIndex + 2% 'remember, indexes are 0 based, so Courtyard is 0, Residence Inn is 1, and so on. So we add 2 to this index to get back to the corresponding row. The URL for Courtyard is on E2 or E(0 + 2) where 0 is the %SelectedIndex%.
In my example, I selected Benjamin, Index 2, and %ExcelData2% brought back www.benjaminhotel.com:
Then, just Launch Chrome with %ExcelData2% and you should be good to go.
Best of luck!
