Hi everyone,
Thank you for taking a look at my question. Having watched Youtube tutorial Import Web data into Excel using VBA Macros https://youtu.be/IOzHacoP-u4 I have run into the following problem:
"Run time error '91':
Object variable or With block variable not set"
Excel debug suggests problem is with the following line
price = html.getElementsByClassName("updated-text box-header ng-binding ng-scope ng-isolate-scope").Item(2).innerText
I have attached the code I am trying to run.
What I am trying to do is query the BA website to get infomation about a particular flight. I have tried a number of classes on the BA website but each time I get the same error.
Thank you for your help,
Alex