Ignore password prompt when opening file

I have the following code:

Dim FSC         As Workbook

Set FSC = Workbooks.Open("http://blahblahblah.com/g086032.xls")

This opens the workbook - but the workbook is on my company's intranet, and it asks me for a username and password. I can just hit the escape key, and the file will load just fine, but I cannot figure out a way to get VBA to "hit escape" during the loading phase.

I've also tried the following code without any luck - it seems as though the code does not finish the "Set FSC" line (as the popup pops up) so it can never execute the application.sendkeys code.

Dim FSC         As Workbook

Set FSC = Workbooks.Open("http://blahblahblah.com/g086032.xls")
Application.SendKeys (ESCAPE)

Any ideas?