VBA Macro - Extract Price and Flight Info from Skyscanner

[fatboy_1989]

Hi,

Could somebody please help me to extract information from the 1st & 2nd flight from the following link on Skyscanner using Excel VBA?

Please reply with annotated/commented code as my VBA skills are not fantastic so I like to know what happens within the macro and not just press play blindly

An example flight i need the information for is:
https://www.skyscanner.net/transport/flights/lond/berl/170901/170908/

I would like to extract the following for the 1st two flights suggested by Skyscanner:

• Outward Airport & Time
• Arrival Airport & Time
• Return Departure Airport & Time
• Return Arrival Airport & Time
• Total Price

Note: Even the info and price for the first flight is fine too.

I have tried to use the "Get External Data" > "From Web" option within excel but the in built web browser does not have javascript built in so I cannot get the information I need.

Many thanks

 

[RoryA]

Welcome to the forum.

Please take a minute to read the forum rules, especially the one about cross-posting, and follow them in future.

Cross-posted here:
https://www.excelforum.com/excel-pr...-flight-info-from-skyscanner.html#post4623598
VBA Macro - Extract Price and Flight Info from Skyscanner
VBA Macro - Extract Price and Flight Info from Skyscanner