VBA 400 Error

Hello,

I'm very new to VBA, but am trying to simply get a table of data into my excel workbook so that I can mess with it. I've googled answers and have found something that works with a different website url, but when I put in the URL that I am actually targeting it gives me a VBA 400 Error. Not sure what the difference is between this URL and that. The one I'm targeting is on a private server so not sure if that has anything to do with it?

Sub trial_macro()
Dim thisWb, downloadWb As Workbook
Set thisWb = ActiveWorkbook

Set downloadWb = Workbooks.Open("https://fclm-portal.amazon.com/reports/functionRollup?reportFormat=HTML&warehouseId=MSP1&processId=1002976&maxIntradayDays=1&spanType=Intraday&startDateIntraday=2018%2F01%2F20&startHourIntraday=17&startMinuteIntraday=0&endDateIntraday=2018%2F01%2F21&endHourIntraday=5&endMinuteIntraday=30")

downloadWb.Worksheets(1).Range("A1:U2613").Copy Destination:=thisWb.Worksheets(1).Range("A2")

downloadWb.Close

End Sub

Here is my code.

Any help would be greatly appreciated.

Thank you,

angus1995

Before you are trying to open and download it, you should test the URL as a link and see what you get. I have got a proxy server error. It might be an Intranet sever which means you might need some kind of authorisation to access it.