I have set up a query that returns a list of approx. 30 webpages (these change daily) from a fixed web address, this is then used in a second query along with a custom function which gets a specific table from each webpage.
Is there a way of getting multiple tables from each webpage in a single function?
Each webpage contains four table which I would like to retrieve, and the only way I can figure it can be done is by having multiple instances of the secondary tables that each call a different function. Unfortunately this isn't an option as just running the single table took 8 mins to return the full list of tables.
Should be possible, but hard to say how without seeing the page structure, all depends on the web page structure.