Need vba sub to open the external web for data import but pause to select a link in the page

[2909]

Hello,

Im trying to import data into an excel sheet from a webpage however the user has to select a page from there (separate sessions) to import. So id need the macro sub but with a "pause" for the user to select the site... ideas?

Thanks