Hi all,

I am currently working on a fantasy football league sheet, and i am importing the lists of players and theyre scores from a website that runs a national league.
The problem is, the link i need to use for the import is not the actual homepage but a link that opens a new window from the homepage.
When i first set up the web query and hit refresh data, everything works fine, but as soon as i shut down, upon reopening the sheet, the link is lost and the sites homepage is displayed.
I have to set up the query manually as i know nothing about vba, does anybody know how to sort this?

any help greatly appreciated