I have a list of approx 100 (it varies depending on when I am using it) URLs and they each have some information recorded against "schedule" - for example "WedFort1"
Two examples:
I've figured out how to pull the data in using PowerQuery but it runs in to some issues with credentials when other users try to refresh the table.
So instead, I am looking for a piece of VBA that would look at the first URL and pull the 'schedule' and then the second URL and pull the schedule and so on until they have all been pulled.
Some won't have a schedule and they should return a blank, or "Not found" or something.
Thanks in advance for any advice.
Two examples:
I've figured out how to pull the data in using PowerQuery but it runs in to some issues with credentials when other users try to refresh the table.
So instead, I am looking for a piece of VBA that would look at the first URL and pull the 'schedule' and then the second URL and pull the schedule and so on until they have all been pulled.
Some won't have a schedule and they should return a blank, or "Not found" or something.
Thanks in advance for any advice.
