I have various web queries that pull data into a workbook whenever I open it up, but the problem is the data is behind a login page. How I currently operate is I open a new web query, navigate to the login page, log in and then close the query, and (I assume) the cookies from the web query remember my log in for the entirety of my excel session, so I am then free to refresh the other web queries without problem. The amount of workbooks I use now however has started to get quite large, and so every time I open a new one it needs me to log back in using the above technique which is becoming a pain. Does anyone know of a macro or VBA code that will automatically log me in, so that I can then refresh my data as I please, or indeed any other method? I thought this would be a common issue, but I've been looking around and there doesn't seem to be a need for this, which I found surprising. Any help is appreciated, thanks in advance.