VBA Macro - Extract Price and Flight Info from Skyscanner

[fatboy1989]

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 code as my VBA skills are not fantastic so I like to know what happens within the macro and not just press play blindly

https://www.skyscanner.net/transport...ine=t1#results

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

Many thanks

[PFDave]

Something to read when you get the chance:

http://analystcave.com/web-scraping-tutorial/

[fatboy1989]

Thanks, looks like that will come in handy in the future.

Hopefully the solution somebody provides for this problem covers most of the link you've provided.

[fatboy1989]

Wow, Didn't realise this would be so difficult to solve as nobody has been able to provide a solution.

Has anyone got any methods to help solve this?

[fatboy1989]

Hi

Can somebody please tell me how i can get the flight prices from skyscanner? When I go into the developer mode in Chrome on skyscanner, i cannot even locate the prices shown on the web page so i then have no idea how to even automate getting them into excel if i cannot even find them

Thanks


Crossposted:
http://www.ozgrid.com/forum/showthread.php?t=204195

https://www.mrexcel.com/forum/excel-...ml#post4831817

http://www.vbaexpress.com/forum/show...806#post361806