Hello,
I have set up a macro to navigate a website and scoll through a series of search parameters, then pull the result into spreadsheet.
Whilst it does work, it is messy because I am doing it via "click search button" then "click on resulting link" ie the actual process that you would do manually. There is a lot of processing and I find that the page crashes and then the whole thing freezes
I'm sure that there is a way to bypass the search and get directly to the site I want, however I notice that the URL doesn't change during the searches, so there doesn't seem to be an obvious way of getting there directly.
The website in question in question is: Tax Practitioners Board
I guess my main question is how to determine the address of the sub page so I can go there directly.
For example to loop through a list of mycodex
I can't copy and post my code...I'm not sure why, it won't work so hopefully this is enough to go on.
I have set up a macro to navigate a website and scoll through a series of search parameters, then pull the result into spreadsheet.
Whilst it does work, it is messy because I am doing it via "click search button" then "click on resulting link" ie the actual process that you would do manually. There is a lot of processing and I find that the page crashes and then the whole thing freezes
I'm sure that there is a way to bypass the search and get directly to the site I want, however I notice that the URL doesn't change during the searches, so there doesn't seem to be an obvious way of getting there directly.
The website in question in question is: Tax Practitioners Board
I guess my main question is how to determine the address of the sub page so I can go there directly.
For example to loop through a list of mycodex
Code:
ie.navigate range("source").value & "/" & mycodexI can't copy and post my code...I'm not sure why, it won't work so hopefully this is enough to go on.
