I have code to pull general data from a website into Excel using a macro, e.g. yahoo finance quotes. But, is it a possibility to pull data from a secure website (one that requires login) to automate a report? The link provided was close, but I don't understand how to pass the parameters in. Also, when I run this I only get a dialog box with an "X" and nothing else... An edit: I am pulling from SAP SuccessFactors I can get the macro to pull a PDF, associated with a URL, but it won't grab an ad hoc Excel report. If anyone has any ideas that would be great!