fatboy_1989
06-07-2017, 12:59 AM
Hello,
For any flight selected in Skyscanner I want to only show direct flights and want to know how to do this via excel VBA. So I want "Direct" to be checked but "1 stop" and "2+ stops" to be unchecked.
The HTML code i've located which may help with the VBA required for the "Direct", "1 Stop" and "2+ Stops" is:
An example webpage might be: https://www.skyscanner.net/transport/flights/lond/hkg/170825/170903
<-- li data-id="direct" -->
<--label class="clearfix two-line"-->
<--span class="label-text"-->Direct
<--input type="checkbox" checked="checked"-->
<--span class="filter-sub">£111
<--/label-->
<--/li-->
<--li data-id="one_stop"-->
<--label class="clearfix two-line"-->
<--span class="label-text">1 stop
<--input type="checkbox" checked="checked"-->
<--span class="filter-sub"-->£163
<--/label>
<--/li>
<--li data-id="two_plus_stops"-->
<--label class="clearfix two-line"-->
<--span class="label-text"-->2+ stops
<--input type="checkbox" checked="checked"-->
<--span class="filter-sub">£197
<--/label-->
<--/li-->
Note: I have replaced "<" and ">" with "<--" and "-->" because not doing this meant it actually shows a checkbox in the message!!
Many thanks
For any flight selected in Skyscanner I want to only show direct flights and want to know how to do this via excel VBA. So I want "Direct" to be checked but "1 stop" and "2+ stops" to be unchecked.
The HTML code i've located which may help with the VBA required for the "Direct", "1 Stop" and "2+ Stops" is:
An example webpage might be: https://www.skyscanner.net/transport/flights/lond/hkg/170825/170903
<-- li data-id="direct" -->
<--label class="clearfix two-line"-->
<--span class="label-text"-->Direct
<--input type="checkbox" checked="checked"-->
<--span class="filter-sub">£111
<--/label-->
<--/li-->
<--li data-id="one_stop"-->
<--label class="clearfix two-line"-->
<--span class="label-text">1 stop
<--input type="checkbox" checked="checked"-->
<--span class="filter-sub"-->£163
<--/label>
<--/li>
<--li data-id="two_plus_stops"-->
<--label class="clearfix two-line"-->
<--span class="label-text"-->2+ stops
<--input type="checkbox" checked="checked"-->
<--span class="filter-sub">£197
<--/label-->
<--/li-->
Note: I have replaced "<" and ">" with "<--" and "-->" because not doing this meant it actually shows a checkbox in the message!!
Many thanks